ok i can parse a date from mySql date field so it displays as: 08/06/1972 but if i insert it into the field in this format then the date gets hosed. do i have to insert as yyyy-mm-dd can i have a form field that has mm/dd/yyyy but then change it on insert? how would i do this? thanks. -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php