Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Range to Summarize by Quarter

How do I create an expression to take the date column and break it up by quarters. For example 1/1/2016 to 3/31/2016 = 2016Q1

Thank you!

1 Reply
sunny_talwar

May be create it in your master calendar script:

Creating A Master Calendar

LOAD Date,

          Year,

          Month,

          Year&'Q'&Ceil(Month(DateField)/3) as YearQuarter