Scheduled report to run as of a date with a start date exactly one month less 1

[jchewsmith]

I am trying to create a report that will be scheduled to run the 26th of every month with a date range filter >=26th of prior month to < 26th of current month?
So for example the report should run as scheduled on May 26th with the data being based on a filter of April 26th to May 25th

 

[pmax9999]

Enter the following code into the record selection formula:

[Code Record_Selection_Formula]
{Table.DateField} >= DateSerial(Year(CurrentDate),Month(CurrentDate) - 1, 26) and
{Table.DateField} < Date(Year(CurrentDate),Month(CurrentDate), 26)
[/Code]

Cheers
Pete