Filtering Date fields gives no records found.

[Avnish Kumar]

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

[John]

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