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:

    - Sam

    Sam Jones
    Vice President, Product and Technology

    The Data Collaborative, Inc.
    366 Massachusetts Ave, Suite 203 | Arlington, MA 02474