>In addittion to what Vlad said:
>
>SQL Server does not have DATE fields, it only has DATETIME fields. You can deal with that at the time you define your (remote) views and tell VFP to convert DATETIME fields to DATE, though.
>
>Keep in mind that SQL Server for example does not handle empty dates. In SQL Server a DATETIME field is either NULL or has a value. The minimun DATETIME value that you can have in SQL Server is 1/1/1900.
>
>
>
>
>SQL Server dates
>>I intend to write application based on local views which will be upsized to SQL Server or Oracle. Is there any things I should not do that may cause compatbilty problem when I upsize later?
>>
>>Eg. Can I used function in my SQL such as :
>>
>>SELECT patient_id,lastvisit(),.... where lastvisit is a UDF.
>>
>>Regards

Actually the minimum datetime is 01/01/1753, smalldatetime starts at 01/01/1900.
If a date is not specified, 01/01/1900 is used.
HTH,