Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Date picker saving 100 years out

Questions related to using nuBuilder Forte.
Post Reply
MLeggy
Posts: 7
Joined: Mon Jul 13, 2020 4:23 pm

Date picker saving 100 years out

Unread post 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.
You do not have the required permissions to view the files attached to this post.
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Date picker saving 100 years out

Unread post by kev1n »

treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Been thanked: 2 times
Contact:

Re: Date picker saving 100 years out

Unread post 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
MLeggy
Posts: 7
Joined: Mon Jul 13, 2020 4:23 pm

Re: Date picker saving 100 years out

Unread post 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.
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Date picker saving 100 years out

Unread post 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 ?)
admin
Site Admin
Posts: 2815
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Date picker saving 100 years out

Unread post by admin »

Kev1n,

Fixed.


Steven
Post Reply