Originally Said By: Jason Byrnes
add the following code at line 1:php:
<?php
if(isset($_POST['ContactDOB']) && $_POST['ContactDOB'] != "") {
$_POST['ContactDOB'] = date("Y-m-d", strtotime($_POST['ContactDOB']));
}
?>
Hi Jason, thanks for the update that hasn't changed anything I'm afraid, I even change the above code to d-m-Y to match the earlier code sent across. Have attached the revised php file, I have ensured the code is being sent back by inserting data into another field on same form, that updates perfectly.
An odd thing does happen, when I view any record on update page the ContactDOB field always displays 01-01-1970, if I change to 17-03-1968 and select 'update' the details page & MySQL table shows 0000-00-00? If I then choose 'update' again it displays 01-01-1970 on update page!
Sorry to be a pain, really cant work this out!
Gary
