I am trying to build a workflow to update certain dates based on a based date. As far as I know if can only be possible via SPD workflow. Here is the logic:
- I have three date fields. BaseDate, D1 and D2.
- Formula for D1 and D2 are:
- D1 = BaseDate + 7 days
- D2 = D1 + 14 days
When a new item is created or an item is edited, the BaseDate can be empty. The user should have the ability to edit any date (BaseDate, D1 or D2) and the user entered value should take precedence over calculated value.
I have taken three date type columns and will be updating column based on formula. But am still not able to check for all conditions. Any help would be appreciated for building my formula. I am using MOSS 2007.