I have a list of items that have a due date and a completed date. I already have logic that does the calculation, and determines whether a 10 day SLA has been met, and populates an "SLA met?" field with a Yes/No and an "SLA +/- Days" field (gives me a zero or negative number if the SLA was met or exceeded, and a positive number if the SLA was missed).
Now what I would like to do is schedule a workflow to run weekly and report out on the items that were completed in the previous 7 days, and whether the SLA was met for each or not and by how much.
I figure I need to use a site workflow so that I can schedule it. I also figure I need to Query List, filter for show items when column SLA Met = Yes, and store it in a collection variable. I can get these items into a notification, but I don't know how to limit the collection to just items that were completed in the past 7 days.