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

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • UweG
    • UweG
    • 2 yrs ago
    • Reported - view

    if “Date field” then “Date/Time” else “No Date/Time” end

    Like
    • UweG
    • UweG
    • 2 yrs ago
    • Reported - view

    Or: if not “Date field” then “do something”

    Like
  • Like Uwe said,

    Or to check if someting is empty you can also use null. 

    “Date Field” = null

    “Date Field” != null

    Steven

    Like
    • Blued
    • Blued
    • 2 yrs ago
    • Reported - view

    Thank you very much

    null instead of “” or “if not” both worked very well

    Like
Like Follow
  • 2 yrs agoLast active
  • 4Replies
  • 575Views