Recordset::Filter ?

What if you were to try this:
rsRecordSet.Filter = " Date >= #" & CStr(DateSerial(2004,11,01)) & "# "

My understanding is that this would work.


"js" wrote:

 > Hi, I just found the filter on date is based on the computer date settings.
 >
 > sometime rsRecordSet.Filter = " Date >= #11/01/2004# " return 0 if I
 > change mycomputer setting to
 > "English(Canada)" and short date format as "dd/mm/yyyy".
 >
 > How to fix this? Thanks.
 >
 >
 >