Skip to main content
Question

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
------------------------------
This topic has been closed for replies.

  • SamJones1
  • Registered
  • June 10, 2020
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
------------------------------
- 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
Terms & ConditionsAccessibility statement