Forum Discussion
Check for null in conditional column
Hi, I am trying to create a conditional column for a date/time field and need to check to see if the field is null. What should I enter in the Value field on the Add Conditional Column dialog bo...
Using the null in the conditional column should work fine. Here's an example:
You can see in the Date column that it actually shows null. Do you see the same thing in the column you're checking? Or is it something like a blank, or maybe a single space?
Hi KGrice,
Yes my date field shows null.
Because of your reply, I went back and created a new conditional column, with just this criteria and that worked.
Then something told me to add this criteria with the other criteria I'm using, but to put this check for null as the first criteria and low and behold, that worked. So I guess for some strange reason, the null criteria only works (at least for me), if it is the first row.
I guess I can live with that, it's just a bit quirky.
Thank you.
Tracy
Yes my date field shows null.
Because of your reply, I went back and created a new conditional column, with just this criteria and that worked.
Then something told me to add this criteria with the other criteria I'm using, but to put this check for null as the first criteria and low and behold, that worked. So I guess for some strange reason, the null criteria only works (at least for me), if it is the first row.
I guess I can live with that, it's just a bit quirky.
Thank you.
Tracy