I am using a Server Connect query to update a SQL database and need to set a populated date field back to NULL. I can't figure out how to do that. If I leave it blank I the the SQL default date of 1900-01-01. If I put IS NULL or NULL I get an error. Can someone please point me in the right direction.

Note: I am doing this directly in the action, I am not posting a form, but could if necessary.

Many thanks!

Hi Ken,
Just use the default format option in the value field, like:

{{yourValue.default(null)}}

Teodor,

Once again you are my hero . Worked perfect, thanks!