Working with dates

[mikawhat]

I have a date column in my db, which is the day that an event will occur. When inserting a new event it works fine. I have a textbox where the user will enter the date in this format: 2007-10-20. When updating the date though i get a null date in the db 0000-00-00. Is there a specific way to insert and update dates?

P.S. Same thing with time...

[rajug]

If your field is of date type (not datetime) then it should be fine. Try to trim out the input. It would be easier to say if you give your code and database structure here. So could you please post your code here?

[mikawhat]

I think i got it to work. I'll post the code if i have any other problems. Thanks for your post.