Forum Discussion

QBuserQBuser's avatar
QBuserQBuser
Qrew Cadet
8 years ago

Display Fiscal Year

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.

2 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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's avatar
    QBuserQBuser
    Qrew Cadet
    8 years ago
    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())