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", …)