<td class="WADADataTableCell"><input type="text" name="ContactDOB" id="ContactDOB" value="<?php echo(str_replace('"', '"', $row_WADAtblcontacts['ContactDOB'])) ?>" size="32" /></td>
to:
<td class="WADADataTableCell"><input type="text" name="ContactDOB" id="ContactDOB" value="<?php echo(date("d-m-Y", strtotime($row_WADAtblcontacts['ContactDOB']))) ?>" size="32" /></td>
Hi Jason, that does indeed allow me to add the date in UK format on the insert page but once 'update' is selected it writes it the the database as 0000-00-00, this then displays like that on the details page?
MySQL table format is 'Type = Date', 'Default=NULL'
Is it possible to store it in the DB as 31/01/12 so that displays on detail page?
Regards
Gary