Automation to change due date to tomorrow at 9am for cards that are overdue - at 4pm every day

Katja_oj4zcw

trying to set up an automation that at the end of the day (4pm) checks if any cards are overdue and then changes their due date to tomorrow at 9am, so I don't miss any cards - please help, tried and partly succeeded but just end up with random times assigned

Jovin

Hey Katja,

Automation can be a frustrating beast at times! Try giving the below a shot:

1. Trigger: Scheduled
   1. Run rule every: 1 days
   2. At: 4pm (Your Timezone)
   3. Check the box for "Run a JQL search and execute actions for each issue in the query"
   4. Set your JQL as below, this looks for anything due before midnight tonight in the duedate field (change the fieldname as required), you could also just use {{now}} if you're sure all required tickets have a due date before 4pm.
      duedate <= {{now.plusDays(1).withHour(0).withMinute(1)}}
2. Action: Edit issue
   1. Select the fields as "Due Date"
   2. Set the value to: {{now.plusDays(1).withHour(9).withMinute(0)}}

Let us know if this works!