how to summarize data group by specific date range?
Summarywant to summarize not in a regular calendar date range
In OAC or DVD
For example, I have a table with detail data from Jan. 01~ Dec. 31.
I have another table to define the date range for summary. Let's say, summarize data from Jan.01 ~ Feb.15 (start_date Jan 01, end_date Feb 15), Feb 16 ~Mar 20 (start_date Feb 16, end_date March 20)...etc. The date Range could be random depending on the business requirement.
how to summarize the data by specific date range?