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
PHP Programmer - interactivetools.com