Date range in WHERE clause

11 posts by 3 authors in: Forums > CMS Builder
Last Post: May 11, 2020   (RSS)

By gregThomas - May 11, 2020

Hey Terry, 

No worries, glad I could help. It's probably the most interesting bug I've looked into this year.

If you're just storing a year as opposed to full date, I think using a text field makes more sense, you just need to be a bit careful with how MySQL handles the ordering of strings - which is why I added the * 1 to the end of the year fields. 

Greg Thomas







PHP Programmer - interactivetools.com