Forum Discussion

aschlafer's avatar
aschlafer
Regular Visitor
7 years ago
Solved

Converting Fiscal Year Text to Number

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?

 

Need Help
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    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

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    7 years ago

    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

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    Hi, aschlafer 

    You could use this formula to create a calculate column

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

    Result:

     

    Best Regards,

    Lin