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...
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
Thanks for trying that out. I tried as well and got the same issue. When I added a second condition to my column, it worked fine with the null check as the first step. When I moved the null check down to the second position, I get an error and the column wouldn't work.
Can't think of an intended reason for this. Sounds buggy.