Hi Sergey

You're my personal consultant here at the UT. Thanks a lot for your help and hope to be helpful for you someday as much as you’ve been to me.

Thanks for the hint.

I suppose that the date regional setting depends on the IIS machine. Am I wrong?

Oscar



>This works for me

oRs.Open("SELECT * FROM orders ;
>		WHERE order_date BETWEEN {^1992/05/01} AND {^1992/05/31}")
>

>>Hi everyone
>>
>>I'm creating a SQL select statement for an ASP page which connects to a VFP database through ADO
>>
>>I’ve successfully executed the SQL statement and displayed the returned data when the “where” clause does not include any date selection criteria.
>>
>>How should the where statement should be constructed on order to make a selection between dates?
>>
>>Does the braces should work for date expresions?
>>
>>Testing with the TasTrade database and the orders table I’ve unsuccessfully tried things like this
>>
>>“…where order_date >= {1994/01/01}”
>>
>>“…where between(order_date, {1994/01/01}, {1994/12/01}”
>>
>>Thanks in advance for any help.
>>
>>Oscar Corte