Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have shown here a screenshot of my pivot table where date in label of last column is incorrectly shown as 31-Feb-2020 and it should actually be 28-feb 2020.
My expression for label is ='Balance as at '&Day(MonthEnd(Date#(PERIODID,'D')))&'-'&Date(Date#(PERIOD,'YYYYMM'),'MMM-YYYY')
Kindly help me to get it corrected.
Hi,
Try with
Date(monthend(Date#('01'&PERIOD,'DDYYYYMM')),'DD-MMM-YYYY')
Hi,
Try with
Date(monthend(Date#('01'&PERIOD,'DDYYYYMM')),'DD-MMM-YYYY')
Thanks It works,
But I want to what does it mean by
'01'
in your expression. Pls clarify for me to learn
It's just for represent in the date the first day of month. It's the DD in DDYYYYMM.
Thanks