Search by date format 16-DEC-1972

[TheDigglerUK]

Hi i am having a problem doing searches using my date format. I enter dates in the format 16-DEC-1972. I cant seem to search showing newest, oldest first etc. Also how can i just display this weeks, today, this month etc.

Any help would be great.

Thanks

Jules

[cretaceous]

if you're talking about a "date" field in mysql you should be entering dates in
YYYY-MM-DD format then it will work as expected (numbers only not month abbreviations)
otherwise it won't...

[bradgrafelman]

In other words, assuming your date values are properly stored in DATE columns, you're going to end up trying to compare '1972-12-16' with '16-DEC-1972' - two strings which obviously don't match.

If you want to continue using the '16-DEC-1972' format to search DATE values, then consider first reformatting that date into the YYYY-MM-DD format. For example, you could do this conversion inside the SQL query itself using something like MySQL's STR_TO_DATE() if available.