Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try like this
Month(Max(Date))
Month(AddMonths(Max(Date), -1))