SQL Server does not understand VFP datetime literals
TableName.FieldName >= '2010-04-01' and TableName.FieldName < '2010-05-02'
>
>What is the right syntax for BETWEEN with two DateTime values (in SQL Select called from VFP app)? I am using the following syntax and getting an error:
>
>
>TableName.FieldName between {^2010-04-01 00:00:00} and {^2010-05-01 00:00:00}
>
>
>The error I am getting is "Syntax error or access violation"
>
>What am I doing wrong?
>
>TIA
--sb--