Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@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.
@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.
Hi, Please try
Count({<start_date={"$(=Today())"}, completion_date={"$(=Today())"}>} id)