17 Replies Latest reply: Mar 23, 2015 5:40 AM by Bhagirath Shingote RSS

    Set Analysis with Dates

    Bradley Isaacs

      HI

       

      I want to show the data for a specific date.  Can you help me with the set analysis syntax for that please?

      (It't the CreatedDateTime field).  I want to show it for Today() -1.

       

       

       

      =Count({$ <Status={"ACTIVE"},Allocated_Ind={"Unallocated"}, CreatedDateTime_Incident={'=$(=Today()-1)'}  >} DISTINCT IncidentNumber)