I am using SP Server 2010 and Nintex Enterprise 2010.
I have a custom SharePoint list called ''Accredited Suppliers'' with the 4 columns below:
- Contract of Services Expiry Date (Calculated field)
- Performance Review Expiry Date (Calculated field)
- Insurance Expiry Date (Calculated field)
- Status of Supplier (Choice field with several options such as ''Compliant'',
''Non-Compliant'', ''In Progress'' etc)
I have created a site workflow to check whether any of the 3 calculated date fields above are less than or equal to the current date and, if so, then the ''Status of Supplier'' field value needs to change to ''Non-Compliant''.
The workflow runs but it won't update the status for any of the expired suppliers in the list. Can someone please provide simple instructions on how to achieve this result as I need this working urgently and am obviously doing something wrong!