Forum Discussion

AnneMcCarthy1's avatar
AnneMcCarthy1
Qrew Member
2 years ago

Filter Monthly, Quarterly, Yearly from one Date field

I have a table with a Maximum Date field. I'd like to create a chart that I can filter by Month, Quarter, and Year. I have managed to create 3 different charts (one for each), using formulas on that ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

well, you can make a field called YYYY and have a formula calculate that field.

Then a field called Quarter and calculate the Quarter # as 1, 2 , 3 or 4.

Then a field to calculate the month.

Post back if you need help with any of those formulas.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
11 months ago

Mark, I could use help on those formulas.  I have a specific use case tonight that I could use for the Quarter specifically.  I have a simple date field, so want to pull fiscal quarter from that date.  FY starts Oct 1.