I have created a form where the user can enter dates (or not).
If the dates are null, then I set the date value to '0000-00-00'
When I execute the sql stmt, the date is saving as '0000-00-00' no matter what the value.
Here is an example of my code:
sR1_Eff_Date = _POST["R1_Eff_Date"];
if ($sR1_Eff_Date == NULL)
$sR1_Eff_Date = '0000-00-00';
I know this is partly php, but I'm trying to get the values from the form into the appropriate variables then execute an insert insert command.