No that expression is not dependant on date settings. It explicitly uses YYYYMMDD whatever the settings are.
Cetin
>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