how to convert fiscal Period ID 201506 into date,Month and Year

[Karim_Khan]

  Fiscal

[Anonymous]

Looks like it is June of 2015:

date(date#(PeriodID,'YYYYMM')) as Date

If you have some special rules for your fiscal calendar, you have to explain these rules

[Kushal_Chawda]

From which month Your fiscal calendar starts?

[Karim_Khan]

From August

[#5]

Hi try this

SET vFiscalYearStartMonth = 8;

load

Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1 AS FiscalMonth,

YearName(Date, 0, $(vFiscalYearStartMonth)) AS FiscalYear;

resident Abc;

[Karim_Khan]

Its not working,

[Karim_Khan]

Hi Manju,

   Its not working

Regards,

K K

[#8]

for me it is working fine .Can u please provide sample data so that i can help u

[Karim_Khan]

I am totally agree with your concept but the logic which we are applying is not working on my project Data.

Any ways thanks for your help

[Kushal_Chawda]

So You want to derive Calender Year & Month from Fiscal Period?