Quote Originally Posted by pjdub View Post
The order_delivery_date calendar is working on the site and the selected delivery date appears in the email confirmation. However it does not get written to the database. The database values are all "0000-00-00". There has been a mod(not by me)to the original date format into the European d-m-y format. I am assuming that when zen cart attempts to write this date mysql does not like it and hence the 0000-00-00 values. I have looked around but can not find where the sql insert statement is performed. I am hoping to reformat the date data there and solve the problem. Can anyone tell me where the insert can be found. Perhaps it's not an insert... Thanks in advance
Yes, MySQL is particular about the format of data being inserted into DATE or DATETIME fields. It expects information to be entered in UTF, YYYY-MM-DD (or YYYY-MM-DD HH:MM:SS), but can accept some other formats.

I do not know what has been edited or where when you converted dates to DD-MM-YYYY format for display, but you will want to convert it back to YYYY-MM-DD format for the insert statement. If a new variable was created for the new date format, then the easiest way to do this would be to use the original variable for the insert statement.