AnsweredAssumed Answered

Updating a field when comparing one date variable to another

Question asked by darrenfloyd666 on Jan 10, 2019



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?