Utilizing the Now() Function in Set Analysis

[Christopher_Lawrence]

Hey All,

Im looking to see if someone can point me in the right direction as to how I properly set up a set analysis formula that leverages the Now() function and compares it to a date parameter with less than/greater than. I have attached what i currently have to this post (as for whatever reason, it gets locked out if i post the formula in the box), but i am basically attempting to get a count of interviews that have not been conducted at the time of viewing the table (Greater Than).

Any insight would be appreciated!

[Vegar]

Try something like this.

count({<I.CompletedOn={"<$(=now())"}>}I.Invited)

[Christopher_Lawrence]

I think this would work for Interviews that were completed during the current time, opposed to before or after (looking for how to do it with greater than/less than opposed to equal).