>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