Quick mySQL query - blank date on update

I have an update page that includes a couple of date fields that often won't need to be used.

When the form updates, the value '30 November -0001' is being written to the database.

How can I stop this, so that it doesn't enter anything?

In the database in phpMyAdmin, I have the field as a Date field, allowing NULL, and a default value of NULL.

Thanks.

send a copy of your page please.

Details below...

I guess its a quirk of mySQL as much as anything.

I had a look and found this sort of thing as a suggestion, e.g. adding:

<?php
if (isset($_POST["Update"])) {
if ($_POST['Date_Done_in_GIS'] != '') {
$_SESSION['Date_Done_in_GIS'] = ($_POST['Date_Done_in_GIS']);
} else {
$_SESSION['Date_Done_in_GIS'] = Null;
}
}
?>

And changing:

."" . $WA_AB_Split . "".((isset($_POST["Date_Done_in_GIS"]) && $_POST["Date_Done_in_GIS"]!="" )?date("Y-m-d H:i:s", strtotime($_POST["Date_Done_in_GIS"])):"")

to

."" . $WA_AB_Split . "".((isset($_POST["Date_Done_in_GIS"]) && $_SESSION["Date_Done_in_GIS"]!="" )?date("Y-m-d H:i:s", strtotime($_POST["Date_Done_in_GIS"])):"")

But without any luck.

If you know any tricks to force it to enter blank or NULL in the date field when the form is updated without those fields being populated that would be a great help.

In the insert behavior, you have the data type for those columns set to text. change the data type to date instead.

What do I need to change? I don't see anything obvious in the behaviour code, and I can't see the behaviour listed in the Server Behaviour panel to edit.

open the server behavior, on the bindings tab, select each of the date columns, it will show the Format and value selections below, set the format date instead of text.

Sorry if I'm having a moment, but how do I open the server behaviour? I'm looking in the Server Behaviours panel, but don't see it listed?

looks like you have edited some code by hand to cause the server behavior to not be recognized.

send FTP Info and I can update it manually for you.

See below.