0
Test on empty date field failed
Hello,
how can I test if a date field is empty? I used the following commands but they both returned “false”:
“Date field” = “”
“Date field” = 0
I managed with a workaround but it doesn“t seem correct to me:
number(”Date field“) = 0
Thank you very much
4 replies
-
if “Date field” then “Date/Time” else “No Date/Time” end
-
Or: if not “Date field” then “do something”
-
Like Uwe said,
Or to check if someting is empty you can also use null.
“Date Field” = null
“Date Field” != null
Steven
-
Thank you very much
null instead of “” or “if not” both worked very well
Content aside
- 4 yrs agoLast active
- 4Replies
- 668Views