Filter based on whether there is data in a date field?

#1

I want to filter out employees who have a termination date in the $termDate$ field.

I attempted using this formula but suspect that I can’t compare a date field and a string:

if {$termDate$==“Unknown”}
return 1;
else
return 0;

Is there a version of this that would work? Or does it require that the formula be built into a data cube?

Thanks!

#2

Hi Thomas,

I believe you are very close to making this work. I was able to Test with
if ($Term Date$ == “Unknown”) {
return 1;}
else {return 0;}

and then filter >= 1 and it should only show the employees who have an unknown/null term date.

image

2 Likes
#3

Thanks! I got an error when I pasted it in and fiddled a bit, then deleted and re-typed it exactly as shown and it worked. I’m guessing that there was a hidden character somewhere when I copied it from your post.

Anyway, it works!

1 Like