Converting Fiscal Year Text to Number

[aschlafer]

Hi all, 

I'm running into some trouble because our database stores our fiscal year data in text format (i.e. FY16, FY17, etc.) and I need to create a calculated column to help me switch the text to an actual date (i.e. 2016, 2017).

Any suggestions?

[v-lili6-msft]

Hi, @aschlafer 

You could use this formula to create a calculate column

Column = 2000+RIGHT([fiscal year],2)

Result:

Best Regards,

Lin

[Vvelarde · Accepted solution]

Hi, In Query Editor..yo can

1. Add a Column - And Extract - Text After Delimeter --FY This obtain 16 , 17 ,etc

2. a new column =  2000+ ThePreviousColumnCreated,

Regards

Victor