Converting Date field to Fiscal Year

Question

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------------------------------

samjones1 · Answer

Hey Bethany,I think this'll work. 
if(month([date]) &gt; 9, year([date])+1, year([date]))​
&nbsp;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 JonesVice President, Product and Technologyhe/himThe Data Collaborative, Inc.sjones@datacollaborative.com366 Massachusetts Ave, Suite 203 | Arlington, MA 02474------------------------------

Forum Discussion

Converting Date field to Fiscal Year