halo

i'm using MySQL to store a date (using "date" data type). as you know, MySQL stores dates in YYYY-MM-DD format. In order not to confuse the secretaries at work, is there a way i can reverse the input string so when people type DD-MM-YYYY it is sent to the dfatabase as YYYY-MM-DD?

thanks!

check out: www.phpbuilder.com/board/archive/index.php/t-10313262.html

that will result in (for example):

<font face='Courier New'>GetSQLValueString(date('Y-m-d', strtotime($_POST['DateOfBirth'])), "date",</font id='Courier New'>

in your insert or update query in Dreamweaver...