V4 Datepicker not allowing dates greater than Jan 18, 2038

So I’m using Mobiscroll version 4.10.3 and I noticed that if I select a date greater than Jan 18, 2038 it no workie. It appears to work when I first select the date, but when I save it, MySQL saves it as Dec 31, 1969. Why this limitation, and is there anything I can do about this?

Hi @Vincent_Wansink

The v4 demo on the website is looking fine, you can select dates beyond 2038. There might be something else going on.

You might want to try to isolate the picker to a diff page if possible and build up the test case to figure out what causes the problem.

Thanks kovlex. Turns out this is a limitation of an unsigned 32 bit integer which is measured in seconds since Jan 1, 1970, the maximum number of seconds ending on January 18th, 2038. Apparently this limitation exists in a lot of languages including PHP which I’m using. I think I’ll find my issue there.

1 Like