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.



             [TX Type] = {'C'}

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

            >} [Amount])

      Thanks so much.