Time and Date formatting, not updating my database?

I have a form with drop downs for day month and year.

I combine them on the following page so they read YYYY/MM/DD but I can't get it to store the values in my database (MySQL).

I think it must be due to the date not being formatted correctly.

Here is what I have treid so far....

$strDateStart = date(Y, $POST['DateStart_Y']) ."/". date(m, $POST['DateStart_M']) ."/". date(d, $_POST['DateStart_D']);

$strDateStart = $POST['DateStart_Y'] ."/". $POST['DateStart_M'] ."/". $_POST['DateStart_D'];

$strDateStart = date('Y-m-d',$strDateStart);

They display ok but when I add it to a new record it just shows 0000-00-00

Can anyone help please?

Many thanks, Mark

date() takes a timestamp as second argument, so I'm surprised that they "display ok".

as far as I know, mysql date fields accept both the format YYYY-MM-DD and YYYY/MM/DD, you just need to make sure they are singlequoted in your query.

so you could simply concatenate your post variable with either - or / and use it in your query:

$strDateStart = $POST['DateStart_Y']."/"$POST['DateStart_M'] ."/".$_POST['DateStart_D'];

Right, ok sorry. It was me being stupid.
Thanks for your help anyway, you helped me realise my mistakes :-)