Set a field to Null on update

Wappler General Need Help
1

I have a situation where I have an update server action that is suppose to remove a date and give the field a null value. But when the action is run it sets the date field in the database to 1970-01-01 instead of null.

How can I get it to set a null value to a database field on update?

Screen Shot 2021-06-28 at 2.20.26 PM
Screen Shot 2021-06-28 at 2.20.26 PM1952×532 37.7 KB

I even tried setting the field type to varchar but it still adds the 1970 date. Where is it coming from? :frowning:

2

Try {{null}}

1 Like
3

Works like a charm Ken! Thank you! :beers:

1 Like
4

Would love to see this added to the data bindings like we already have {{NOW}}.

4 Likes
5

It would be great if this {{null}} worked from within the database manager, as well. Sadly, it doesn’t!

Does anyone know of a trick how to get null for a date column in the database manager?