Help

Grouping by quarter with specific dates

798 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nate_Streeter
4 - Data Explorer
4 - Data Explorer

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}))

0 Replies 0