I've got a field on a list called 'OS End of Date'. I have a loop on a workflow which stores the dates in a variable called 'Loop'. Then I have a calculate action which is taking the date and adding 6 months to it and storing it in a variable called '6 months looped'.
What I need to happen is that if we're within 6 months of the 'OS End of Date' that it updates a filed called Status to 'Amber'. I've got a Set a condition action and an 'Update item' action but it's not working. Any suggestions?