Date Format Issue

[Karim_Khan]

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.

[sunny_talwar]

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