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.