Hi, we are trying to run an automation however having issues with the last part.
Basically when a CAB is approved and in awaiting production deployment, after 72 business hours once the implantation date has past to add a note in the ticket.
We are getting stuck on the = start of day etc
status = "Awaiting production deployment" AND "Implementation completion date[Time stamp]" = startOfDay(-9)
Hi @Danielle David So the issue with the query is that you're looking for an Implementation completion date time stamp that is exactly 9 days ago at midnight. What you'll need to do is something like this:
status = "Awaiting production deployment" AND "Implementation completion date[Time stamp]" >= startOfDay(-9) AND "Implementation completion date[Time stamp]" < startOfDay(-8)
This will get anything that falls between midnight to midnight 9 days ago.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.