Thanks again Cetin, that's exactly what I was looking for.
Enmanuel
>>>>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
>
>Oh that's easier (got you wrong) :
>
>"select * from myTable "+;
>" where DateField between '"+;
> Dtoc(date1,1)+"' and '"+Dtoc(date2,1)+"'"
Cetin
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain