FY Date to Date

[Prabhu1204]

Hello, 

Is it possible to bring the date from FY.

I have year and I want to bring the Closing date 

Could you please give some suggestion? or is it not possible

[MayilVahanan · Accepted solution]

Hi @Prabhu1204 

Try like below

Load *, Date(MakeDate(2000+Right(Year,2), 3,31),'MM/DD/YYYY') as ClosingDate Inline
[
Year
FY10-11
FY11-12
];

[QFabian · Accepted solution]

Hi @Prabhu1204 , please try this one too :

Data:
Load * inline [
Year
FY10-11
FY11-12
FY12-13
FY13-14
FY14-15
FY15-16
];

left join
Load
Year,
monthend(makedate(20&subfield(purgechar(Year, 'FY'), '-', 2), 3)) as [Closing Date]
Resident Data;