Thanks for that info. It's not a current timestamp that I can use, the date is based on events later this year. And the time isn't an issue and thats why I use the Date column. If I put in a date 30-07-2010 it posts it to DB 0000-00-00 but if i put in 2010-07-30 it posts it to the DB correctly (as per MySQL spec). My problem is that in the UK we use dd-mm-yyyy format, and thats what the end user will enter into form. I am really stumped at this. Would there be any other solutions?