>Hi,
>
>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

SQLExec:

fromDate = date(2010,4,1)
toDate = date(2010,5,1)

... TableName.FieldName between ?m.fromDate and ?m.toDate

ADO:
Simply set adodb.parameter with datetime type and set the value to datetime values.
Cetin