LEFT, RIGHT FUNCTION

[DataAnalyst]

Hello, I have 2 columns with qtrs formatted as Q2/15 and so on.

My calculation for deliquent quarters will look at both these quarter fields. Since i cant subract in this format, I used the LEFT function to extract the year values from both the fields which works fine.

However, when i use the right function to get say the value 2 in Q2/2015, i get all 0s. Is there a regular expression i can use or try something else. I just need number 2 from Q2/2015.  I have tried trim function as well.

Thanks!

[ufarooq]

I have a date in format FY21 and i've taken the Right 2 to give me 21 but i want to append a hard coded 20 before this to give me "2021" how would i do this?

[Luke_C]

Hi @ufarooq: "20" + Right([Year],2). Alternatively: Replace([Year],'FY','20')