mysql date not searchable

[REX]

I have a mysql date column that sorts etc. just fine but if you try to search date: > 12/01/01 it will have no effect?

ahy ideas ...anyone!

[John]

Couple ideas...

Try putting a date delimiter around it, like > #12/01/01#

Also try using the full year, as in: 12/01/2001

Let us know what works.

Thanks,
John



------------
REX at 12/11/2001 3:24:14 PM

I have a mysql date column that sorts etc. just fine but if you try to search date: > 12/01/01 it will have no effect?

ahy ideas ...anyone!