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.