I apologize if this is a newbie question, but such is life.
Scenario: SharePoint2016
A developer completes/submits a form for a project review. The form contains a 'requested launch date' that must be at least 7 days from the current date. This is handled easily with rules/functions.
The form is then picked up by a 'reviewer' who begins a review of the project. The review can take several days, and the reviewer will need to edit the form to update a 'review status' field and other details. All of this is communicated by sending notifications using a workflow.
The issue is when a reviewer edits the form during the review cycle and gets within the 7 day window. The form cannot be saved due to the current validation. The date was fine initially, but the review can, and often will take several days to complete. The rule on the date control will always be triggered.
Best approach to capturing request date, making sure it's at least currentDate+7, then comparing it to the submit date?
Thanks!