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
MarkShnier__You
Qrew Legend
Qrew LegendYear([Date])+
If(Month([Date]) >= 10,1,0)
This assumes that your fiscal year for 2021 starts on this coming October 1st, 2020.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If(Month([Date]) >= 10,1,0)
This assumes that your fiscal year for 2021 starts on this coming October 1st, 2020.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I get an error with the "Year([Date])+" portion of the formula: Expecting text but found number--Bethany DickeyProgram AdministratorMobile Bay National Estuary Program118 N. Royal St., Suite 601Mobile, AL 36602251-459-8870
- MarkShnier__YouThe formula will return a number. if you want a numeric result, then change the field type to Formula Numeric
If you want to retain as a text result and a formula text field type , then convert the result to text like this
ToText(
Year([Date])+
If(Month([Date]) >= 10,1,0))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thanks! It let me save the field with the error and DID actually work on the form.--Bethany DickeyProgram AdministratorMobile Bay National Estuary Program118 N. Royal St., Suite 601Mobile, AL 36602251-459-8870
