Hi all.

I have a leave request form that is currently saved in the repository. When saving after being approved, it also adds metadata, which includes the submitters name, first day off and first day back. A reminder email is sent to the necessary people 7 days before the submitter goes on leave.

My client would like to take this a step further, by having the approved folder searched at the start of the week, and have an email sent out with a list of all employees who will be going on leave that week. Although I can do a general search of the repository, I'm unable to pull the precise time frame.

I have been using a combination of the date token calculator and search repository activities to pull this information. Could someone please provide some suggestions on how I can achieve this? Generating the email isn't an issue, simply searching on a week-by-week basis is.