Migrating form Access to MySQL

[RFH Reseller: UKFlyer]

I have developed a site using an access database but would like other sites to be able to draw from the information so decided to migrate to MySQL. The only issue I have is the date. When a date is now submitted ie using date() to automatically update when a record is changed, or a javascript date picker I get 0000-00-00 instead of the correct date. Also if I have a set of dates in, where as before with the access database I could choose date ranges to display, it now doesn't work.

Like I said it all worked using access. Anything obvious to do?

[RFH Reseller: UKFlyer]

Have sorted this problem.