>>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
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham