How do I test for a null date

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!

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:”

2 Likes

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

Glad to hear it worked for you!