I am trying to wrire a formula so only dates of service from the last four quarters are pulled.
I have tried this formula, but it pulls dates that are included in the current quarter as well as the past 4 quarters.
{Incident_Date} in dateserial(year(DateAdd ("q", -4, currentdate)), (datepart("q",DateAdd ("q", -4, currentdate))*3)-2,1) to
currentdate - day(currentdate)
Here are a few example of what I need the report to do
Example 1:
Date Report was ran: 2/10/2010
Dates that should be included in the report:
1Q2009-4Q2010
Example 2:
Date Report was ran: 10/20/2010
Dates that should be included in the report:
4Q2009-3Q2010
I have tried this formula, but it pulls dates that are included in the current quarter as well as the past 4 quarters.
{Incident_Date} in dateserial(year(DateAdd ("q", -4, currentdate)), (datepart("q",DateAdd ("q", -4, currentdate))*3)-2,1) to
currentdate - day(currentdate)
Here are a few example of what I need the report to do
Example 1:
Date Report was ran: 2/10/2010
Dates that should be included in the report:
1Q2009-4Q2010
Example 2:
Date Report was ran: 10/20/2010
Dates that should be included in the report:
4Q2009-3Q2010