17 Replies Latest reply: Nov 15, 2017 3:23 PM by matt parker RSS

    Before a date

    matt parker

      Attached i have a snap shot of a straight table. I am trying to eliminate any date before the date Today - 2 days (Two Days Ago).

      Below is the expression that gave me the snap shot of the straight table.

       

      Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"}, project_name-={"PMO IMS Pipeline","PMO Test"}>}issue_due_date)

       

      I need to add something like "issue_due_date >= today()-2" somewhere into equation above.

       

      Can anyone tell me how I can get this ("issue_due_date >= today()-2") into the above equation?