Yes, sorry, Y-m-d is the correct format for the database but when my client goes to edit it they're bound to type in d-m-Y or, rather, dd-mm-yyyy which, on submission to database, will cause problems.
What I don't understand about the function CraigR has provided an example of is where in that function it picks up the form field, in my case "LEDProductUpdateDate"?
Should I be replacing "$date" with the name of my form field? So instead of this....
<?php
function formatUKDateMySQL($date) {
$d = str_replace(" ","",$date);
$d = explode('/', $date);
$d = $d[2].'-'.$d[1].'-'.$d[0];
return $d;
}
?>
...it becomes this:
<?php
function formatUKDateMySQL($_GET['LEDProductUpdateDate']) {
$d = str_replace(" ","",$_GET['LEDProductUpdateDate']);
$d = explode('/', $_GET['LEDProductUpdateDate']);
$d = $d[2].'-'.$d[1].'-'.$d[0];
return $d;
}
?>
Also, thinking about this, I'm concerned about what happens if my client lazily types something like 21-1-14 when entering a date.
I'd use a datepicker tool, but I want a default value of "today" in the date field.
As ever, I appreciate your advice and guidance. Thank you.
NJ
