Max(Month) not working

[bhavvibudagam]

Hi Experts,

Can any one please help me on below issue.

I have date field like below.

I have extracted Month as

Month(CreateDate) as Month;

when I have taken Max(Month) and Max(Month)-1 on text boxes getting 12,11 instead of Dec and Nov.

I have tried

Text(Month(CreatedDate)) as Month; but still not working.

Please help me to get month in Dec format.

Thanks in advance.

[sunny_talwar · Accepted solution]

May be try like this

Month(Max(Date))

Month(AddMonths(Max(Date), -1))