I have a report that I'm developing for our sales department. The goal is to get the total sales (by invoiced $) from the same month for the previous year and then use that number plus a percentage as a new goal listed for the current year and current month to date (report runs daily). I have this mostly working and I'm using a sub report to target the previous year / month's sales. The problem is in the selection criteria for the sub report. It's only capturing the sales MTD (previous year) and instead of the full month.
This is what I am using in the report selection:
{ARTABLE.INVOICE_DATE} in date(year(currentdate)-1,12,1) to dateadd("yyyy",-1,currentdate)
How can I modify the selection criteria to report all sales for the current month (previous year). I'm close just haven't been able to get through.