Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › On my update page the date shows in the update form field as 2022-03-21. Can you please advise on how to display as 03-21-2022?

View all replies to this thread

On my update page the date shows in the update form field as 2022-03-21. Can you please advise on how to display as 03-21-2022?

Thread began 4/05/2022 7:18 am by jo271221 | Last modified 4/05/2022 2:58 pm by jo271221 | 785 views | 7 replies

4/05/2022 2:32 pmjo271221

After quite a bit of trial and error I realized that I also need to update the update behavior to allow the insert in that format. I was unable to do with the date format but this seems to work. It will work 4/5/22. Obviously ignoring the hour, minute, second.

Do you have a better solution?

$UpdateQuery->bindColumn("eventdate", "t", "".((isset($_POST["eventdate"]) && $_POST["eventdate"]!="" )?date("Y-m-d H:i:s", strtotime($_POST["eventdate"])):"") ."", "WA_DEFAULT");

$UpdateQuery->bindColumn("enddate", "t", "".((isset($_POST["enddate"]) && $_POST["enddate"]!="" )?date("Y-m-d H:i:s", strtotime($_POST["enddate"])):"") ."", "WA_DEFAULT");

This did not work
$UpdateQuery->bindColumn("enddate", "t", "".((isset($_POST["enddate"]) && $_POST["enddate"]!="" )?date("m-d-Y", strtotime($_POST["enddate"])):"") ."", "WA_DEFAULT");

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.