How do I test for a null date

Charlie_Wells · 04-02-2020 03:00 PM

I need to test for a date in User Settings not having been set by the user. I want it to be unspecified in some cases.

I can’t seem to get USERSETTINGS(“End date:”)=0, ="", =null, =“null”, whatever, to work.

What’s the trick here? I’m feeling pretty stupid!

Derek3

Hi Charlie,

You could try ISBLANK()

For example:
ISBLANK(USERSETTINGS(“End date:”))

This will return True if there is no value set in “End date:”

Charlie_Wells

Thanks Derek, that worked! A tiny fix to my logic also helped :=)

Derek3

Glad to hear it worked for you!