Fiscal Year and Fiscal Month

[prabunakil]

my script is to load

Left (FKDAT,2) as TransDay,

Mid (FKDAT,4,2) as TransMonth,

Right (FKDAT,4) as TransYear,

But the issue is my physical year start with April.

How to load to make it correctly.

[maheshkuttappa]

I am assuming you looking for below,

YearName (FKDAT,0,4)

I am not sure why you are using mid, left and right function instead of the standard calendar function ?

[techvarun]

You need  to add a condtion Like

If(TransMonth= Match(TransMonth,'Jan','Feb','Mar'),TransYear-1,TransYear )as Date,

[prabunakil]

Thyankyou is working fine now.