Run report on specific dates for each month

[dacards]

Using C10, i've searched a few times and can't find the answer to this one, but i feel it should be fairly easy.

Trying to set up a report to run for the fiscal month - which for us is the 22nd of one month to the 21st of the next.

I currently have it set up to run using the following criteria:

({CIT_Audit.Create Date2}=dateadd("m",-1,currentdate) to currentdate -1

But for this to work i need to have it run on the 22nd of each month. I'd like to build it so i can run the report on any date/time and it will pull anything from the 22nd of the previous month to the 21st of the current month.

Your time and help is appreciated.

 

[lbass]

But what do you want to happen if the currentdate is before the 21st of the month versus after?

If you always wanted the previous month to the current month whenever you ran the report in the current month, the formula would be:

{CIT_Audit.Create Date2} in dateserial(year(currentdate),month(currentdate)-1, 22) to dateserial(year(currentdate),month(currentdate), 21)

-LB

 

[dacards]

This is what I needed - as always THANK YOU!