I have been reading all the posts and I still have not worked this out. I have a block. I need to send a notification in a site workflow that will send out a reminder a week before an expiry date is due. I have tried all options and feel that the Calculate Date would provide me with two dates. However, I can't configure the calculate date action to provide a date for the field CCR Expiry Date -7. All the examples given are from the current date minus or plus days but this is for an existing date - 7 days in a list on the site. I may be getting my logic wrong but seem to be going round in circles. I am hoping that when I get this right I will be able to get the for each action right which seems to be picking up the first item in a collection only.
Solved! Go to Solution.
I think i have become bogged down with my thinking. Clarification occurred as soon as I wrote this. So hopefully this will solve the first part of the issues.