I want to set the report up so that I do not have to modify the posting date each month when I run the report.  Currenly I am running the report for the previous fiscial year (2012) which for our company runs 5/1/11 to 4/30/2012.  In May 2013 I will start running the report for fy 2013..5/1/12 to 4/30/2013.

I run the report on the 2nd of each month.

The criteria for the report I ran on 3/2/13 is:

{trx_amt.record}<>0.00 and

{trx_proc_no.record}in[12321, 19824] and

[trx_posting_dt.record] in DateTime (2011,05,01,00,00,00) to DateTime (2012,02,28,23,59,59)

 

Report date 3/2/13: I enter beginning trx_posting_dt 5/1/11 and end trx_post_date 2/29/12.

So on 4/2/13 the dates I enter will be 5/1/11 and 3/31/12

on 5/2/13 the dates I enter will be 5/1/11 and 4/30/12

on 6/2/13 the dates I etner will be 5/1/12 and 5/31/12

on 7/2/13 the date I enter will be 5/1/12 and 6/30/12.