CAB automation - once implantation date has past

Danielle David

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)

Mark Segall

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.