I’m using the below formula to group by quarter. How do I change the dates they are using to determine the quarters? For example, our quarter 3 ended on 9/27, however the formula is including everything through 9/30 in quarter 3.
CONCATENATE(“Q”,DATETIME_FORMAT({Invoice sent date}, “Q”)," ",YEAR({Invoice sent date}))
Grouping by quarter with specific dates
Be the first to reply!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.