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!