Sorry if I confused you, was an exhausting day at work last night.

My client has requested that we use the english date formats, and one of my co-workers working on the project has edited the language files so this can be achieved.

The problem we found is when the user wants to add a special promotion to one of his products, he opens up the zen cart calendar and clicks on the day he would like. This then places the appropriate text in the input field.

The text inserted in the input field is inserted using the ENGLISH date format (dd/mm/yyyy) but the form requires american format (mm/dd/yyyy) - I think this may be something to do with the SQL Table Field being set as a date ?