trouble storing date in DATE field

[Jerico]

When I try and store a date in my DATE field as yyyy-mm-dd, it just gets added as 0000-00-00 when I view it with PHPMyAdmin. I'm not sure what i'm doing wrong

INSERT INTO projects (project_name,project_description,project_start_date,project_end_date,project_date) VALUES ('Sample Project','This is the sample project description','04-06-2011','04-10-2011',now());

[Jerico]

OOps - I see what I did wrong when i posted this question!

Ok - I'll ask another question in it's place.


How should I store dates if i want to do calculations with them? Should I store them as YYYYMMDD? Can I still maybe calculations if they're stored as: YYYY-MM-DD?