When insert/update a empty textfield to datatype date/time in SQL server. I get the field filled with 1899-12-31T05:00:00Z. It is not possible with this extension to assign a NULL value.

The Dreamweaver insert/update behaviours did work with a function:

 <
%' IIf implementation
Function MM_IIf(condition, ifTrue, ifFalse)
  If condition = "" Then
    MM_IIf = ifFalse
  Else
    MM_IIf = ifTrue
  End If
End Function
%>

MM_IIF(Request.Form("date"), Request.Form("date"), null))

I need to insert/update a empty value in date/time

Miroslav told during live support to write a topic about this question. But two weeks further still no response.

Hello,
This is currently not possible. WE will discuss this idea with the team and will try to integrate this feature in the upcoming updates/releases.

That will be nice. I need a date/time field that can be empty (Null)

When will this be solved. I still need Null value for date/time

Quote

This is currently not possible. WE will discuss this idea with the team and will try to integrate this feature in the upcoming updates/releases.

Hi Teodor,

Still waiting to set Null value for date/time database field

Hello,
You can try using:

.default(null)

in the value you insert to your db. Example - if you are inserting {{$_POST.date}} it should become {{$_POST.date.default(null)}}
Please let me know if this properly inserts a null value into the database field.

Hi Teodor,

This doesn't work.

you can test the page with the link i send you yesterday

In my api file

"table": "tbl_test",
"column": "datum",
"value": "{{$_POST.hidden_datum.default(\"null\"}}",
"type": "datetime"

I use a hidden_datum field with Calendar 3. Has it to with this?

Hidden field is not the issue. I will check this with our developers.