Combination of Month and Year

[#1]

I want to display three different dimensions with last 3  'Month Year' combination.

1st Dimension : date(makedate(Year(Now()),Month(Now())),'MMM YYYY')                    display JAN 2014

2nd Dimension: date(makedate(Year(Now()),Month(Now()))-1,'MMM YYYY')                  display DEC 2013

3rd Dimension: date(makedate(Year(Now()),Month(Now()))-2,'MMM YYYY')                   Still display DEC 2013

I expect 3rd dimension to display NOV 2013 but seems it's subtracting days and not month when using makedate() .

Any solution please ?

[Or]

You'll be wanting the AddMonths() function.

[#3]

Misplaced parenthesis?

date(makedate(Year(Now()),Month(Now()))-2,'MMM YYYY')

date(makedate(Year(Now()),Month(Now()) -2) ,'MMM YYYY')

[Nicole-Smith · Accepted solution]

I would suggest going with the following:

1.  date(now(),'MMM YYYY')

2.  date(addmonths(now(),-1),'MMM YYYY')

3.  date(addmonths(now(),-2),'MMM YYYY')