OK, children, gather around...

This is the way you do it:

1 MODIFY yourdatabase
2 MODIFY your remote view (in the view designer, rightclick on your remote view and select Modify
3 Go to Fields Tab
4 Click Properties button between the field mover lists
5 Select a datetime data item in the View Field Properties form
6 Under Data Mapping, select Date
7 Repeat for any other datetime items you need to work with as dates

Once you've done this, there are a few additional things to keep in mind. When a NULL date comes across from SQL Server to VFP, it's date shows up as 30/12/1899 (don't ask!) When a BLANK date comes across, it shows up as 1/1/1900 (again, don't ask!). SO, you may want to write a conversion routine that converts those strange dates to VFP blank dates before they are displayed. It is no fun, but that's the way it is. also, when you write a date back to datetime, you lose the time portion (actually, it is blank).

So be kind to your date, always, and try to understand how she works!

Pertti