Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I have to calculate a date which will be "now+90 days"

Rupali Choudhari
Contributor
August 3, 2023

I have to calculate date A which will be "now+90 days". The catch is that , if the date is falling on a weekend, date A should be next Monday from that weekend date.

Date A=  (now+90 days) if it is Weekend, select date as the next Monday.

 

How do we use Jira smart value for this Jira automation?

1 answer

1 accepted

2 votes
Answer accepted
Tim Perrault
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2023

Hi @Rupali Choudhari 

 

You could try something like below

{{now.plusDays(90).toBusinessDay()}}
Rupali Choudhari
Contributor
August 3, 2023

@Tim Perrault Actually we want to calculate date which is 90 days from now including the weekends but if that comes to be Saturday or Sunday then fill with next weekday which will be monday.

Tim Perrault
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 3, 2023

@Rupali Choudhari  Is the automation not working for you? It should calculate out 90 days and then if that 90 days is a non business day (Saturday or Sunday) then move it to Monday

Rupali Choudhari
Contributor
August 4, 2023

Thanks @Tim Perrault . The automation rule worked.

Like Tim Perrault likes this

Suggest an answer

Log in or Sign up to answer