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:โ
Thanks Derek, that worked! A tiny fix to my logic also helped :=)
Glad to hear it worked for you!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |