Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Generate Custom Quarters using date column

Hi,   I have a date column that has dates from 01/01/2018 to 30/09/2019. Using this date field by default I can get calendar Quarters. But my requirement is to generate custom quarters using speci...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Use a SWITCH statement like:

     

    Quarter = 
  SWITCH(
    TRUE(),
    [Date] >= DATE(2018,9,27) && [Date] <= DATE(2018,12,31),"Q4",
    [Date] >= DATE(2019,1,1) && [Date] <= DATE(2019,3,4),"Q1",
    [Date] >= DATE(2019,3,4) && [Date] <= DATE(2019,9,30),"Q2",
    "Q3"
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Use a SWITCH statement like:

 

Quarter = 
  SWITCH(
    TRUE(),
    [Date] >= DATE(2018,9,27) && [Date] <= DATE(2018,12,31),"Q4",
    [Date] >= DATE(2019,1,1) && [Date] <= DATE(2019,3,4),"Q1",
    [Date] >= DATE(2019,3,4) && [Date] <= DATE(2019,9,30),"Q2",
    "Q3"
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler  Thanks for the quick response. It worked.