Date Format Issue

Karim_Khan — Tue, 21 Jul 2015 13:17:44 GMT

Hi ,

How to chnage the date number format 41356 into standard date format 20-Jul-2015.

am changin the date into Script by appying below code

Year(Date#([Fiscal Period ID], 'YYYYMM')) as StandardYear,

Month(Date#([Fiscal Period ID], 'YYYYMM')) as StandardMonth,

(Date([Fiscal Period ID], 'YYYYMM')) as Date

I have the Fiscal period ID through which am fetching this data.Is there any other way to get teh Month,Year and Date.

Fiscal Period ID 201506 etc.

Re: Date Format Issue

sunny_talwar — Tue, 21 Jul 2015 13:22:12 GMT

Try this:

Year(Date#([Fiscal Period ID], 'YYYYMM')) as StandardYear,

Month(Date#([Fiscal Period ID], 'YYYYMM')) as StandardMonth,

Date(Date#([Fiscal Period ID], 'YYYYMM'), 'DD-MMM-YYYY') as StandardDate