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