I have a “Today” column in Sharepoint that needs to be set at the current date, I understand the [Today] does not work in the calculated column formula. I have read that you can create a workflow that will set a “today” column to today’s date, will modify the workflow to repeat, pausing for 12 hours at a time, so that we always have “Today” as today’s actual date. I have tried to do that and it does not seem to be working correctly or at all. Not sure what I am doing wrong, is there any Nintex How-to’s I can follow to set this up to work? I need it to calculate and update 30-60-90 day before expiration for certifications.
Side note, we had migrated our site from 2013 to 2019 and it seems to be stuck on the today date that it was moved. Not sure if that caused this to not work or if there is a glitch/change in 2019. It seemed to have worked before. All workflows have been republished.
