I have a report where the end user wants to enter the month and year in the report and then it will show data based on that month and year selected. The problem is I also need it to back 90 days because the report is averaging PO usage for the past 3 months. An example would be if you type in the month 12 and year 2014 you get usage for October, November, & December. The current formula I have is
month({PO_DATE})={?Month Number} and
Year({PO_DATE}) = {?Year}

If anyone has any way this could be accomplished it would be appreciated.

Thanks

I get a date range is required here error, highlighting the 0 to 2.

You can do somewhat like below.

If Datepart('m',YourDate) In Datepart('m',Dateadd('q',-3,Date(({?year},{?month},01)))
to DatePart('m',(Date(({?year},{?month},01))) Then YourData

I Will explain the parts.

Datepart('m',Yourdate)

Will Give the month of your Data date .

Datepart('m',Dateadd('q',-3,Date(({?year},{?month},01)))

Will give the month of 3 months before the input date.

DatePart('m',(Date(({?year},{?month},01)))

Will Give the month of input date provided.

I used this formula, but it is only giving me data for the month that I enter and not the three months before. I have listed the formula below.

If Datepart('m',{PO_DATE}) In Datepart('m',Dateadd('q',-3,Date({?Year},{?Month Number},01)))
to DatePart('m',(Date({?Year},{?Month Number},01)))

Thank You



Edited by ridershaun - 30 Jan 2015 at 2:49am