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
Thank you for this. Been stuck on it for a while and moved the null check to first condition and now it works fine.