How to convert fiscal year to calender year

[#1]

I have financial year :2014-2015 and Month : july I want to convert it into date : 01/07/2014

Financial year is from Apr 2014- Mar 2015

[MK_QSL]

Load

  *,

  If(Date<=3, MakeDate(Right(Year,4),Date),MakeDate(Left(Year,4),Date)) as FinalDate;

Load

  Month,

  Dual(Month(MonthStart(Date#(Month,'MMM'))),NUM(Month(MonthStart(Date#(Month,'MMM'))))) as Date,

  '2014/2015' as Year

Inline

[

  Month

  Apr

  May

  Jun

  Jul

  Aug

  Sep

  Oct

  Nov

  Dec

  Jan

  Feb

  Mar

];

[#3 · Accepted solution]

makedate(if(num(month)>3 and num(month)<=12,left(fiscalYear,4),right(fiscalYear,4)),num(month(fiscalDate)),day(fiscalDate))

cheers,

kunal bhattacharjee