This format works - with a single quote around the value.
lt=TRANSFORM(DATETIME())
?lt
select * from tbltable where flddt = '10/14/04 08:50:37 AM'
or
select * from tbltable where flddt = '10/14/04'
I would suggest going into Enterprise Manager and playing around with queries in the Query editor.
>Hello,
>
>From VFP8, I execute some SQL requests through ODBC.
>The data sources can be SQL Server, DBF tables (odbc), MySQL, and so on...
>A problem appears when I want to construct requests with dates.
>According to the SQL system, the syntax for dates are different.
>Ex.: ...where date='10-14-2004' works on SQL server but does not work with DBF tables.
>Is there a 'universal' syntax which can work on all SQL systems ?
>Any tips ?
>
>Thanks for your help.
>Regards,
>Steph
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown