Page 1 of 1
Date picker saving 100 years out
Posted: Tue Jul 14, 2020 6:43 pm
by MLeggy
Hello,
I have a strange thing happening. When I use the date picker on a form it shows today's date in red.
When I save it actually saves 1920, not 2020
dates.jpg
The date format in MySQL is set to Date not Datetime.
Any help would be much appreciated.
Re: Date picker saving 100 years out
Posted: Tue Jul 14, 2020 6:50 pm
by kev1n
Re: Date picker saving 100 years out
Posted: Tue Jul 14, 2020 9:52 pm
by treed
Did exactly that on my app yesterday to resolve this issue. I needed to go each date object and save it with the new format for it to take effect. How about that there really is a Y2K bug. ;-0
Re: Date picker saving 100 years out
Posted: Wed Jul 15, 2020 8:15 am
by MLeggy
Created a new Format.
Applied it to the date field on the form. (probably didn't need to do this)
Applied it to the input of the Object
Sorted, much appreciated.
Re: Date picker saving 100 years out
Posted: Wed Jul 15, 2020 8:07 pm
by kev1n
The default date should be dd-mm-yyyy and it was changed here:
https://github.com/steven-copley/nubuil ... aa465d10db
But the latest nubuilder4.sql doesn't contain this change anymore (@Steven: Reverted by mistake ?)
Re: Date picker saving 100 years out
Posted: Sat Jul 18, 2020 1:50 am
by admin
Kev1n,
Fixed.
Steven