Find a Quarter based on custom quarter boundaries


Hi! I had a question regarding length of time between two dates

So I know that the quarter() function determines the quarter based off January 1st

is there any way to determine the quarter based on an arbitrary start date? for example, if my quarter started on 3/1, could i make Q1 - 3/1-6/1?

You would have to create your own calculated field. Something like this:

in pseudo code: MyQuarter= (if month number = 3,4,5 then 1 ) etc… -

Our IF() statements are multi-section, like this IF(age< 3, “toddler”, a>=3 and <5, 'pre-schooler", …)