CReate Date from a field

[akpofureenughwu]

Good day friends, I'm working on a job, I need to produce a chart with Month, Quarter and Year data but they were arranged in a table with this format: 20150413 meaning Year 2013 April 13Th. How do I convert format to produce Month, Quarter and Year.

[sunny_talwar]

I see, but the script he provided included all upper case DUE DATE

[ajsjoshua]

Hi Brother,

Year field is not giving the correct answer.

[edmondo_tassi]

use num to transform the date in Excel like format, then reformatting as U want.

best regards