Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Period Wise data in my table like 201401,201402,201403........201412 but as my requirement I need to display like
January 2014 ,February 2014,March 2014
in my pivot table can anybody help me on this..
Thanks,
kishore.
Try this:
Date(Date#(YourField, 'YYYYMM'), 'MMMM YYYY')
Date(makedate(left(YourField,4),right(YourField,2),1), 'MMMM YYYY')
Hi kishore
you can try with this below function
Date(makedate(left(YourField,4),right(YourField,2),1), 'MMMM YYYY')
Thanks