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?

We discussed this in our session yesterday and I forgot about it.
I have attached the page. The column names are eventdate and enddate

Thank you for the help yesterday. I really appreciate it!

You should use 03/21/2022, not with dashes. Dashes are recognized as the european format and will be understood as day-month-year instead of month/day/year.

The formatting can be done with the date function like:

<?php echo(date("m/d/Y",strtotime($Recordset->getColumnVal("dateField")))); ?>

Thank you,

Can you please update the code below for me. I attempted and failed miserably. This is on an update page.

For some reason the update is not working correctly. I now have 11/30/-0001 instead of 4/5/2022

Make sure your datatype in your Update Server Behavior is set to date for those columns. It looks like you have it set to string.

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");

I warned you that using dashes would cause problems because php recognizes it as European format: D-M-Y. That is why your final example wouldn't work.

You shouldn't need to reformat it in the bindColumn(). The webassist function should do that automatically if you use "t" data type. I think this would work:
$UpdateQuery->bindColumn("eventdate", "t", "".(isset($_POST["eventdate"])?$_POST["eventdate"]:"") ."", "WA_DEFAULT");