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 withi...
Forum Discussion
Hey Bethany,
I think this'll work.
------------------------------
- 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
------------------------------
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
------------------------------