Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
makedate(if(num(month)>3 and num(month)<=12,left(fiscalYear,4),right(fiscalYear,4)),num(month(fiscalDate)),day(fiscalDate))
cheers,
kunal bhattacharjee
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
];
makedate(if(num(month)>3 and num(month)<=12,left(fiscalYear,4),right(fiscalYear,4)),num(month(fiscalDate)),day(fiscalDate))
cheers,
kunal bhattacharjee