Comparing a date within a range

[Anonymous]

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.

[Anil_Babu_Samineni]

Perhaps this?

sum({< [TX Type] = {'C'} ,[Reporting Date]  = {"$(=AddMonths(Date(now(0)),-3))"} >} [Amount])

[marinadorcassio1]

Hi,

More precisely, I think :

sum({< [TX Type] = {'C'} ,[Reporting Date]  = {" > $(=AddMonths(Date(now(0)),-3))"} >} [Amount])