Skip to main content
Question

Display Fiscal Year

  • October 26, 2017
  • 0 replies
  • 46 views
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.
      This topic has been closed for replies.

      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?
      • QBuserQBuser
      • Author
      • Registered
      • October 26, 2017
      Thanks for the quick response.  I  just created the following formula and it seems to be working.

      If(Month()>=1 and Month()<=8, Year()-1,Year())
      Terms & ConditionsAccessibility statement