Forum Discussion
Yuiitsu
3 years agoHelper V
Create custom quarter
Hi!
My company has a different quarter pattern from usual so I need to create a custom quarter column.
My company quarter works like this:
Q1 from April 1st to June last day
Q2 From July 1st to September last day
Q3 from October 1st to December last day
Q4 from January 1st to March last day
I found in another post something like this:
Company Quarter = SWITCH( TRUE(), [Date] >= DATE( [Year], 1, 16) && [Date] <= DATE([Year],4, 15), "Q1", [Date] >= DATE( [Year], 4, 16) && [Date] <= DATE([Year],7, 15), "Q2", [Date] >= DATE( [Year], 7, 16) && [Date] <= DATE([Year],10, 15), "Q3", "Q4" )
However I do not know how to change the above to something I can use.
Please help!
Thank you.
try this:
Company Quarter = SWITCH( TRUE(),[Date] >= DATE( [Year], 4, 1) && [Date] <= DATE([Year], 6, 30), "Q1",[Date] >= DATE( [Year], 7, 1) && [Date] <= DATE([Year], 9, 30), "Q2",[Date] >= DATE( [Year], 10, 1) && [Date] <= DATE([Year], 12, 31), "Q3","Q4")
3 Replies
- FreemanZSuper User
try this:
Company Quarter = SWITCH( TRUE(),[Date] >= DATE( [Year], 4, 1) && [Date] <= DATE([Year], 6, 30), "Q1",[Date] >= DATE( [Year], 7, 1) && [Date] <= DATE([Year], 9, 30), "Q2",[Date] >= DATE( [Year], 10, 1) && [Date] <= DATE([Year], 12, 31), "Q3","Q4")