Automate changing incomplete due date to nearest Monday or Friday

Question

Is it possible to use Butler to change an incomplete due date to the nearest Monday or Friday once the initial due date has passed?

e.g.

- Original due date: Monday 1st Feb (incomplete at end of day) butler moves to Friday 5th Feb;

- New due date: Friday 5th Feb (incomplete at end of day) butler then moves to Monday 8th Feb

Reason being, I have two admin days each week (Monday & Friday) and therefore if I miss the original due date set I'd like the due date to automatically move to my next admin day.

Vongsawat · Answer

You need to set a "Mon" and "Fri" label. You can set the labels to have no colour, that way it doesn't show up on the card front.

Then you need a new Rule. It uses a combination Variable {cardduedateweekdayshort} to automatically set the label equal to the due date. But only the first time.
To be able to set the name of the label in the command, just choose any "add label" command of the same colour, add it, and then you can change the name of the label to be added.
It requires the "Without the x label" portions (which when stacked like it is below, is considered to have an OR relation) so that the Due Date Rules below that move the due date doesn't trigger this Rule again.

Then you need two new Due Date Rules. One for when the Mon due date hits, swaps the labels, and moves the Due Date to Friday. And then the opposite for the Fri due date.

Hope that helps.

milynnus · Answer

@Laura Kingsley

See this page

https://support.atlassian.com/trello/docs/arithmetic-and-formatting-in-date-variables/

something like {cardduedate+1w=1wd} for card not completed on Friday, then move card to Monday list.

since you have two specific days you might want to have them on two different lists so that you can bump the dates correctly.

Try it.