{PD_CDDPDRACCMAS_RECORD.CH_DIS_DT} in DateTime (2012, 06, 01, 00, 00, 00) to DateTime (2012, 11, 30, 23, 59, 59) and
{PD_CDDPDRATRANS_RECORD.TRX_COST_CTR} in [7250, 7251]

 

I need this report indefinatley to run on the 25th of each month.

 

I want to be able to schedule the report so I need to figure out a way for the discharge dates (ch_dis_dt) to advance without manually  doing it and take into consideration that the year will also change within the criteria as well as on the schedule date. 

 

I assume I need to do this in the parameters and then add to the formula but I'm not sure how to go about this.

 

Below is a list showing the date the report is to run and then the beginning ch_dis_dt and the ending ch_dis_dt for each month it is to run but again this is indefinately so the run dates will be 2014, 2015, etc so I am looking for something that I will never have to change the dates no matter what year the report is running in. 

 

Feb 2013   06/01/2012-11/30/2012

Mar 2013   07/01/2012-12/31/2012

Apr 2013   08/01/2012-01/31/2013

May 2013   09/01/2012-02/28/2013

Jun 2013   10/01/2012-03/31/2013

Jul 2013   11/1/2013-04/30/2013

Aug 2013   12/1/2013-05/31/2013

Sep 2013   01/01/2013-06/30/2013

Oct 2013   02/01/2013-07/31/2013

Nov 2013   03/01/2013-08/31/2013

Dec 2013   04/01/2013-09/30/2013

Jan 2014   05/01/2013-10/31/2013