Thank you Jason. The extra closing script tag is inserted whenever I add a Datepicker to the page so can I log that as a bug with you?
The sample code you've provided, to reformat the date when it is submitted...does that go above the Insert code or is that held within the body section?
I had considered a select list for the time but was concerned about the length of the list.
Also, relating to how the time is submitted to the database, I created a TIME field in my MySQL database but when I look at that in an ODBC connected Access database whilst it does log the correct time from my form, it also appears to store the current date. Will that cause me problems?
Appreciate the help. Thank you.