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 LegendThe 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
------------------------------
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 Dickey
Program Administrator
Mobile Bay National Estuary Program
118 N. Royal St., Suite 601
Mobile, AL 36602
251-459-8870
