Display Fiscal Year

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Is there a formula to convert a date to a Fiscal Year (YYYY format).

I am thinking that if in my settings I have that the Fiscal Year starts in September then I should be able to use a formula to convert a transaction date to the fiscal year.
Photo of QBuser

QBuser

  • 370 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
No there is no formula function for fiscal year.  You will need to make a formula to calculate it.  What are the rules for the fiscal year?
Photo of QBuser

QBuser

  • 370 Points 250 badge 2x thumb
Thanks for the quick response.  I  just created the following formula and it seems to be working.

If(Month([Transaction Date])>=1 and Month([Transaction Date])<=8, Year([Transaction Date])-1,Year([Transaction Date]))