AnsweredAssumed Answered

Site workflow to alert when a set time has elapsed

Question asked by darrenfloyd666 on Nov 21, 2018
Latest reply on Dec 3, 2018 by darrenfloyd666

Hi wonderful Nintexers


I have an Applications list which has a End of Life column. What I need to happen is that a RAG Status column is updated as Amber if it's 12 months after the date in the End of Life column and Red if it's 18 months after.

I've done a similar thing a long time ago so I'm a bit rusty. In the site workflow I've got a Query List action and a Calculate Date which looks up the Applications lists gets the End of date field adds 12 months and stores it in a date variable called date_12month. Am I heading in the right direction? Also how would I check that the date to update the RAG Status column?

Any help appreciated!