Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Display Fiscal Year
QBuser QBuser
10-25-2017 22:13
Is there a formula to convert a date to a Fiscal Year (YYYY format). I am thinking that if in my settings ...
QuickBaseCoach Dev./Training
10-25-2017 22:18
No there is no formula function for fiscal year. You will need to make a formula to calculate it. ...
QBuser QBuser
10-26-2017 03:08
Thanks for the quick response. I just created the following formula and it seems to be working. If(Month([Transaction ...
1.
Display Fiscal Year
1
Like
QBuser QBuser
Posted 10-25-2017 22:13
Reply
Reply Privately
Options Dropdown
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.
RE: Display Fiscal Year
0
Like
QuickBaseCoach Dev./Training
Posted 10-25-2017 22:18
Reply
Reply Privately
Options Dropdown
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?
3.
RE: Display Fiscal Year
0
Like
QBuser QBuser
Posted 10-26-2017 03:08
Reply
Reply Privately
Options Dropdown
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]))
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic