Insert Date Problem

Insert Date Problem

I have set up a simple mysql DB with 2 fields, Name and Date (I have used DATE in MySQL). I then have used Dataassist to create insert, detail and report pages. When I post a date on insert page using 30-04-2010 it just displays 0000-00-00 on the detail page. I am new to database, PHP and MySQL. Can anyone point me in the direction of what I am doing wrong?

Update page not working correctly

Jason, thanks for sending through that info. I have now got most of it up and running except for the update page. When I insert a new record, all is fine, when I go to the update page the correct date format is showing, problem is when I change the date and submit it again I just get an empty page and it doesn't post the new changes to the DB. Any solutions?