I'm setting up a report to be generated every week to show on-time deliveries.
I have a similar report to show me the on-time deliveries for the previous day.
and the formula for that is something like:
{ShipDate} = (currentdate-1)
my question is what formula do i use to give me data from (7 days ago to currentdate-1) ?
I don't want to set up a manual parameter because i want the report to be sent automatically from the system as an IQAlert, so i need the parameter to be embedded in the report as a selection formula.