Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › datepicker field storing all dates to database as 1/1/70 no matter what user selects?

View all replies to this thread

datepicker field storing all dates to database as 1/1/70 no matter what user selects?

Thread began 1/28/2020 3:16 am by Nathon Jones Web Design | Last modified 8/12/2020 6:19 pm by Nathon Jones Web Design | 1649 views | 14 replies

8/10/2020 11:27 amNathon Jones Web Design

Hi Ray,

I was sure we had this one resolved but I've spotted another occurence of this problem on this site, where the date defaults back to 01-01-70.

If you sign into the site with the user information provided below and select order ref 3835, you will see six tabs across the top:
Certificate / Step 1 / Step 2 / Step 3 / Step 4 / Step 5

Each of the "Step" tabs has an "Edit & Save" button at the bottom.
If you go to Tab 1 and click "Edit & Save", it reverts the date back to 01-01-70, however this doesn't happen if you select the "Edit & Save" button on any of the other Step tabs.

Can you see why this is? FTP details provided below also.
Thank you.
NJ

EDIT:
On an update form, should the defaultDate be null in the datepicker script, considering that value should be being populated from database?
Could this be the cause of the 01-01-70 issue?

EDIT 2:
Commented out the defaultDate: null line in the script and now it's saving the date as 04-08-01!?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.