Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to automate checklist due dates so they won't fall on a weekend.

Pamela Laurie August 31, 2023

I used automation rules to set due dates for items on a checklist based on a custom field: "Event Date".  Many things are due either the working day before or the day after the event, so if the event is on a Sunday, the things due the day before should be due on Friday, not Saturday.  If an event falls on a Saturday, the things due the day after should be due on Monday, not Sunday. 

I have been using: set the item due on the date in custom field "Event Date" minus 1 working days or plus 1 working days, but it is pushing those items to either Thursday or Tuesday, respectively.

1 answer

1 accepted

0 votes
Answer accepted
Deleted user September 23, 2023

Hi Pamela,

Not sure if you've already solved this? I found your question while looking for an answer to my own similar issue.

Perhaps this will help, from the arithmetic and formatting resources (here)

"Note: In working days values, {date+1wd} is not the next working day but the date after a working day has passed. This subtle distinction only matters if the date falls on a weekend: Saturday +1 working day is Tuesday. To obtain the next working day, use {datelong+0wd}; to obtain the previous working day, use {datelong-0wd}."

Pamela Laurie November 9, 2023

Tara, THANK YOU!!!  No, it had not been answered, so I've been manually changing it this whole time.  I was sure there was a solution but it just hadn't made it to the top of my priority list to dig into it further so I kept hope alive that someone would respond. 😁

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events