You can map Sql Server datetime field to the date type in a view.
>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
--sb--