Greetings,

I'm doing a SQL passthrough to MS SQL Server. I have a date time field in my SQL server that I would like to have come back as a date instead of datetime.

Example: Select invoicedate, customer from invoicedate

Currently I'm getting date time in the invoicedate field so when it dumps to Excel I have extra data I do not need. Of course I can just re-select the data into a cursor to do the conversion in VFP but I would like to know how to convert to a date in a single query.

Thanks in advance!


Greg