I've got a from with a standard date field. The form is mapped to a mysql table containing a date column. The form filed stores the date as dd-mm-yyyy, but mysql requires the date in yyyy-mm-dd format. I could map the date field to a text column and then convert to a date column after but it would be better to insert the data in the right way immediately after submission of the form. Is there a way to do this?
Please sign in to leave a comment.