But nothing I’m doing works. I need a sanity check here, so if someone has the correct set up, I could try that and if it still doesn’t work I can dig deeper into why it doesn’t work.
Hi there, @casheets123… I have been tripped up on more than one occasion when checking something against the current date because the constraint also takes the current time into account, so nothing gets returned. Have you tried using two constraints with the first one being a check that the modified date is greater than the current date/time with hours, minutes, and seconds changed to 0 and the second constraint being a check that the modified date is less than the current/date time with hours, minutes, and seconds changed to 23, 59, and 59? Those constraints have done the trick for me in the past, so maybe that’s what you need here.
Thanks for keeping my sanity in check guys @keith and @mikeloc
I found the issue in the end. There wasn’t anything wrong with the date part, it was completely unrelated, the workflow was trying to change something that didn’t exist yet. Duh!