Discussions

Expand all | Collapse all

Converting Date field to Fiscal Year

  • 1.  Converting Date field to Fiscal Year

    Posted 06-09-2020 16:36
    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
    ------------------------------


  • 2.  RE: Converting Date field to Fiscal Year

    Posted 06-10-2020 16:47
    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
    ------------------------------