Hello,

I am upsizing an FPDOS 2.6 app to SQL server and wish to keep code intact as much as possible. To this end I am using remote views with good results, but have found a problem with dates because SS does not have pure date fields, so I am using use datetime fields instead.

Unfortunately, this means that date arithmetic code needs to be changed by adding calls to conversion functions such as DTOT(), TTOD(), or perhaps CTOD(). However, I wish to avoid having to change code by hand as much as possible. Is there a way to handle this globally?

Normally I use date arithmetic to calculate the difference between two dates, giving a result in days, or adding a number of days days to a date.

TIA,

Alex