Databridge V2 with MySQLi support IS Now Available!

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 | 425 views | 14 replies

8/12/2020 5:21 pmNathon Jones Web Design

Hi Ray,

Yes, if you change the DOB field on the form and then change another field which then fails validation, the selected DOB isn't retained, it reverts back to the recordset value.

I assume it's this that's at fault?

<?php echo(isset($_GET['v1'])?ValidatedField("vieworder_201","SMCformDOB"):$rsEDITFORM->getColumnVal("SMCformDOB")?date("d-m-Y",strtotime($rsEDITFORM->getColumnVal("SMCformDOB"))):""); ?>

I feel like this is the last issue with this DOB field. Hope you can help resolve it.

Thank you.
NJ

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.