Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
4 years ago

Converting Date field to Fiscal Year

I need a formula that will convert [Date] that I enter to show the fiscal year that it goes with. Our fiscal year is October 1 - September 30. I've already got my fiscal year starting in October within the app properties. This seems like it should be a simple formula, but I can't seem to figure it out.

------------------------------
Bethany Dickey
------------------------------
Formulas and functions

1 Reply

Sort By
  • SamJones1's avatar
    SamJones1
    Qrew Cadet
    4 years ago
    Hey Bethany,
    I think this'll work. 
    if(month([date]) > 9, year([date])+1, year([date]))​

     
    If you need more help with it, swing by Data Collaborative's free Office Hours, every Thursday at 1pm Eastern.

    Sign up here:
    https://data.quickbase.com/db/bqeqqj33i



    ------------------------------
    - Sam

    ______________________________________________
    Sam Jones
    Vice President, Product and Technology
    he/him

    The Data Collaborative, Inc.
    sjones@datacollaborative.com
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474
    ------------------------------