2 Replies Latest reply: Aug 9, 2018 9:08 AM by Marina Dor RSS

    Comparing a date within a range

    Jason Post

      Hey everyone,

       

      I am trying to sum all values that have a reporting date with the last 3 months. I am looking for only charges, [TX Type] = {'C'}. Is there a way to say:

       

      Reporting Date > AddMonths(Date(now(0))),-3)


      This is the expression I currently have, obviously with the Reporting Date bit missing.

      sum(

            {<

             [TX Type] = {'C'}

             ,[Reporting Date]  = _?_?_?_?_?_?_?_?_?_

            >} [Amount])


      Thanks so much.