2 Replies Latest reply on Apr 3, 2017 11:57 AM by John Bowling

    Turning a Flag on if the date is between a start date and an end date

    John Bowling

      I have been asked by our Operations Manager to see how many projects a PM has active at any given time.  He would like ues last year's data.

       

      Each [Project_ID] has a [Booking Date] and an [Completion Date].  If the day on the graph is between these dates, add one to the count of "Active" projects.

       

      Sounds simple.  I tried

       

      if DATE()>=min([Booking Date]) and

          date()<=Max([PSR_Summary (DATAMART)].[Completion Date])

          then "Active" ELSE "Not Active" END

       

      Cannot get it to work.