Insert Date Issue

[obrienkev]

Hi all,

If $closed_date isn't set I want '0000-00-00' inserted into database. Instead '--' is all that's inserted and thus query doesn't work.

// process date **********************************
if(isset($closed_date))
{
list($day, $month, $year) = split('[/.-]', $closed_date);
//echo "Day: $day; Month: $month; Year: $year<br />\n";
$closed_date = $year.'-'.$month.'-'.$day;
echo '<h3>'.$closed_date.'</h3>';
}
else {
		 $closed_date = "0000-00-00";
		 echo '<h3>'.$closed_date.'</h3>';
}