I'm looking for a way to calculate a set of dates for reports, for our business quarters which are.
4/1/xxxx to 6/30/xxxx
7/1/xxxx to 9/30/xxxx
10/1/xxxx to 12/31/xxxx
1/1/xxxx to 3/31/xxxx
On any given date that the report is run I need it to calculate valid start and end dates for the last 4 quarters.
Then I will take those dates and run the 4 reports.