Home > Forum > General > View filter on empty date

View filter on empty date

0

05.07.2021

21:23

Hi Community!

I tried to create a view which returns all elements from a specified workflow that have a datetime field NOT set (empty),
but that seems to be impossible.

I do not know how to filter that, a standard filter in the view with selected field equals to <empty> value in textfield
does not solve that.

I am pretty sure there is a trick how to do that I am not aware of ;-)

Many thanks in advance & best regards, Nik

05.07.2021

23:56

Hi Nik,

my best bet is the following:
Create a calculated column, where you use ISNULL to return a predefined value if the field doesn't have a value.
You can than use this value in an additional filter for the specific view.

One other approach would be to use a sql query in the source tab but this will be applied to each view.

Edit: I wonder why I didn't use a case expression to return 0/1 (true/false) :)

Best regards,
Daniel