Filtering Date fields gives no records found.

Hi,

We used to work on the older version of ASPDB (ASPDB2001-05.07-SP3-ADO21-MTS-Gold) and used to give the criteria for filtering date fields on our page as 'between '10/01/2001' and '10/05/2001' and used to work like a charm. We recently installed the latest patch of ASPDB (ASPDB2001-10.01-SP3-ADO21-MTS-Gold) and this doesnt give any records for the above filter.

Note. Database records and fields have not changed and this is confirmed by our QA using 2 different machines using the same database and same source code.

Please advice.

Thanks

Avnish

HI Avnish,

Just tested it on the latest DLL and it seems to work for me. What kind of database are you using? Try replacing the '10/01/2001' with #10/01/2001#.

Thanks,
John


------------
Avnish Kumar at 10/15/01 2:29:05 PM

Hi,

We used to work on the older version of ASPDB (ASPDB2001-05.07-SP3-ADO21-MTS-Gold) and used to give the criteria for filtering date fields on our page as 'between '10/01/2001' and '10/05/2001' and used to work like a charm. We recently installed the latest patch of ASPDB (ASPDB2001-10.01-SP3-ADO21-MTS-Gold) and this doesnt give any records for the above filter.

Note. Database records and fields have not changed and this is confirmed by our QA using 2 different machines using the same database and same source code.

Please advice.

Thanks

Avnish