Today Function in Set Expression

[Scas1]

Hi all,

I'm trying to figure out how to use the today() function within a set expression. Right now, I have this code:

Count({<start_date={"<7/29/2022"}, completion_date={">7/29/2022"}>} id)

Which does exactly what I want, but obviously is not dynamic. I've been trying to figure out the syntax to turn the 7/29/2022 date into today, but nothing I have tried has worked. Thanks!

[sidhiq91 · Accepted solution]

@Scas1  Please see the below expression. 

Count({<start_date={'<$(=Date(Today(),'MM/DD/YYYY'))'}, completion_date={'>$(=Date(Today(),'MM/DD/YYYY'))'}>} id)

If this resolves your issue, please like and accept it as a solution.

[Anku]

Hi, Please try

Count({<start_date={"$(=Today())"}, completion_date={"$(=Today())"}>} id)