I'm using sharepoint 2007 and my requirement is to have an email sent to a user should it reach a certain date of the month and the user hasn't updated a list item.
So the way it currently works is that a user submits a form and I have a workflow which creates a document which the users manager needs to fill out by the end of the month. I am creating a workflow which will check a list item to see if it's updated and if not I want it to send an email. My issue is timing; the form can be submitted at any time of the month, however they will be reviewed and cleared on a monthly basis. I want my workflow to check the list item 5 days before the end of the month (month on month) and send a reminder mail if not completed but I can't figure out how to identify the end of the month in a variable to create a workflow step.
Eg. If the user submitted the form on 2nd of April, I want to start a workflow to check for completion on 26th of April. If they submit it on 10th of May, I want my workflow to check for completed on the 27th of May etc. Always 5 days before the end of the month it was submitted during.
Am I missing something very easy? Everything that I search is based on date calculations, ie. +30 days but in my scenario it's dependent on a recurring monthly date, not a specific amount of time.
Thanks in advance for any help anyone can offer.