MySql date error
3 posts by 2 authors in: Forums > CMS Builder
Last Post: February 25, 2019 (RSS)
By rez - February 22, 2019
I keep getting this error you can see at the top when trying to save a record (screenshot uploaded).
I found something in this forum about it and didn't understand so i just upgraded this site to the latest cmsb but that didn't help.
I can save the event when selecting "neverRemove". It also works if I set the remove date to 2020 for some reason.
This all started when the client ran out of dates that I had up to 2018. So I used the blank option in administration to make the last and next 5 years always available.
Thanks for any help.
By daniel - February 25, 2019 - edited: February 25, 2019
Hi rez,
I think this is likely because there is no February 29 in 2019, as it's not a leap year, though 2020 is.
Let me know if that solves the issue!
Thanks,
Technical Lead
interactivetools.com
By rez - February 25, 2019
Ha! Well that explains it. I didn't try any other day since that is what the client was trying.