>>How can I send a date value to an ADO recordset? For example I got two date variables: date1 and date2 and I want to select only the records between these two dates.
>>
>>TIA,
>>
>>Enmanuel
>
>

>oRs.Filter = 'DateField >= #'+;
>  	Transform(Dtoc(date1,1),'@R 9999/99/99')+;
>  	'# and DateField <= #'+;
>  	Transform(Dtoc(date2,1),'@R 9999/99/99')+'#'
>

Cetin

Thanks Cetin that worked. But how can I pass this value on the select statement instead of the filter property? I've tried passing this same example code but didn't work.

Enmanuel