Displaying date as dd-mm-yyyy and inserting to MySQL DATETIME field?

The date is always stored in your table in the format YYYY-MM-DD.

You can manipulate how this appears on screen just by formatting it according to the php date format function

eg echo date('l F j, Y', strtotime($row_recordset['MyDate']));

http://www.w3schools.com/php/func_date_date.asp

Regardless how it is formatted, it needs to be saved back into the database table in the YYYY-MM-DD format.

To do this, I pass the date field value into a function to set the appropriate date format.

eg if I am using the datepicker tool, the date is displayed on screen as dd/mm/yyyy (We in the UK like it the proper way round)

when saved back into the database table, I pass the field value through a function

<?php
function formatUKDateMySQL($date) {
$d = str_replace(" ","",$date);
$d = explode('/', $date);
$d = $d[2].'-'.$d[1].'-'.$d[0];
return $d;
} 
?>

so the dataassist insert behavior includes a line like this...

"".((isset($_POST["MyDate"]) && $_POST["MyDate"]!="" )?formatUKDateMySQL($_POST["MyDate"]):"")  .""