Forum Discussion
MarkShnier__You
Qrew Legend
yes, you can use a formula to calculate the fiscal year. Can you tell us what your rules are for the fiscal year start with an example?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TonyGonzalez
5 months agoQrew Trainee
Mark,
Of course. We start our FY Oct 1 and the FY # is the following year. i.e. Oct 1, 2023 is the start of the FY 24 year.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
- MarkShnier__You5 months agoQrew Legend
Here is one examnple that calculates to a formay like FY24
var number FiscalYear = If(Month([Invoice Date])>=10, Year([Invoice Date])+1, Year([Invoice Date]));"FY" & Right(ToText($FiscalYear),2)or else this would be numericIf(Month([Invoice Date])>=10, Year([Invoice Date])+1, Year([Invoice Date]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------