I would like my workflow in SP Designer 2013 to only run if it is within 7 days of my column [Hire Date], otherwise, pause until that date. I see how to create the column if it is exactly 7 days from the hire date, but if the item is created 3 days before, I'd like it to run as well. I need a statement like "If t[Current Date] is 7 days or fewer from [Hire Date] then start workflow, Else, pause until 7 days before. My current column is =DATE(YEAR([Hire Date]),MONTH([Hire Date]),DAY([Hire Date])-7) How can I make it "or 6,5,4,3,2,1" days?
A possible way of doing this would be:
Within your workflow create a local variable called "PauseUntilDate", and get its value as
PauseUntilDate = Hire Date - 7 days
Next write a pause until statement to make the workflow wait until "PauseUntilDate"
If the "PauseUntilDate" is yet to come, the workflow will begin execution on the designated date.
If the "PauseUntilDate" has already passed, the workflow will realize this within about 5 minutes and run the next statement.
And of course, delete the calculated column, you don't need it anymore.
You can try making the workflow pause based on a boolean field calculated with following formula;
=IF((DATEDIF([Hire Date], Today(),"d") <= 7),"")
Read more about principals used here
Please Note: This solution will only work if workflow is triggered on item create or item update.