Period Conversions

[#1]

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.

[tresesco]

Try this:

Date(Date#(YourField, 'YYYYMM'), 'MMMM YYYY')

[#3 · Accepted solution]

Date(makedate(left(YourField,4),right(YourField,2),1), 'MMMM YYYY')

[#4]

Hi kishore

you can try with this below function

Date(makedate(left(YourField,4),right(YourField,2),1), 'MMMM YYYY')

Thanks