>Hi everybody,
>
>We had a discussion today about date vs. datetime field and I want to get your valuable input.
>
>We currently use Visual FoxPro native data as our back end but we may go to SQL Server in the future. Is it wise to have all date fields defined as datetime and therefore use ttod(datetimefield) = ? vp_Date in our p-views and index on ttod(datetimefield)? Or should we use date field if there is no sense in datetime field from the user's perspective?
>
>Also I think I read it here recently that SQL Server is going to introduce DATE field. Is it a rumor I'm just starting or a fact?
>
>Thanks a lot in advance for your help.

Nadya,
Why not You try to use CA instead p-views? In CA You can use CursorShema Property. Visual FoxPro uses CursorSchema at design time to determine the structure of the cursor to place on the surface of the Data Environment Designer. Visual FoxPro uses CursorSchema at run time if specified by the CursorFill method. In this case the field in SQL is DATETIME but the correspond field in CA is DATE type.