Replacing 20 with FY

[stevejones1]

Hi

I have year values as 2019 , and 2020 .. i need them to be displayed FY19,FY20 .. using replace function i am getting FYFY for 2020 .. how do i avoid this?

Thanks!

[sunny_talwar · Accepted solution]

May be try this

'FY' & Right(Year, 2) as FYear

[shiveshsingh]

You can do it by Right function..

'FY' & Right(YearField,2) as YearField