[Zope] dd/mm/yyyy date into MySQL

Hi, What would be the best way to take a date in the format 'dd/mm/yyyy' from a form and insert it into a date field in a MySQL table, which takes the format yyyy/mm/dd? I could have seperate fields for day, month and year and piece them together before inserting them in the table. But, is it possible to take a complete date, and change it format before inserting it in a MySQL table? Having looked at the Zope Book nothing obvious jumped out. Regards, Sion -- Computer Support Sion Morris School of Psychology Ysgol Seicoleg University of Wales, Bangor Prifysgol Cymru Bangor Tel: 01248 382469 Fax: 01248 382599