AddMonth Date

[suzel404]

Hi all,

I want to calculate the number of store where the date is up to 4 months.

Identify the store with the date >= to  4 months.

example : the store 4171152 with the date 24/12/2015 is the date up to 4 months.

Thank for your help.

[swuehl · Accepted solution]

What about:

=Count(DISTINCT If(DATE <= AddMonths(Today(),-vDate),STORE_ID))

[suzel404]

Thank you swuehl.

I ittle modify the calculation to Count(DISTINCT {<DATE={"<=$(=AddMonths(Today(),-vDate))"}>}STORE_ID)