1 Reply Latest reply: Mar 13, 2018 10:06 PM by Sunny Talwar RSS

    Max(Month) not working

    bhavani b

      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.

      created date.png

      Thanks in advance.