Previous Month from Today

[azmeerrehan]

I have a requirement where I don't have a filter for Year and Month and the date fIeld is 'YYYYMM'.   By default the report shows the data for the current month.  The expression is a set analysis.  Its working fine, until you hit the 1st of the month. So on the1st of Aug for example I still have the data loaded for Jul 31st  and no Aug Data yet.  So the report will show 0 cuz month(T0day()) is Aug and there is no data for Aug.  I am trying to build a logic  like (If(Day(Today()>1, Month(Today()), Month(Today())-1 for previous MOnth.

What am I doing wrong here ??

[sunny_talwar]

May be this

If(Day(Today()) > 1, Month(Today()), Month(Today() - 1))

[azmeerrehan · Accepted solution]

Doesnt work, but was able to get this work

=If(day(Today())>1,Month(Today()),dATE(Date(Today(),'YYYYMM')-1,'MMM'))

[sunny_talwar]

Strange, but okay