How do I set due date to be the minimum between two dates?

[Laetitia Gascon]

Hi, 

I'd like to set the due date to be the minimum between {{now.plusBusinessDays(1)}} and a custom date field.

My synthax seems to be wrong : 

min({{now.plusBusinessDays(1)}},{{"Customfield[Date]"}} <= endOfDay("+15d"))

Thanks !

Laetitia

[Marta Woźniak-Semeniuk]

Hey @Laetitia Gascon 

So you want to set Due Date to be be set on the closest possible date between tomorrow and the custom date field? 

That would mean you can just set it to the custom date? 

Please elaborate cause I think I am missing something here :) 

[Laetitia Gascon]

Sorry I meant : {{now.plusBusinessDays(10)}

[Laetitia Gascon]

+tomorrow is not a business day :) 

[Marta Woźniak-Semeniuk]

Are you doing this with automation or with ScriptRunner?

[Laetitia Gascon]

Thanks for your quick reply.

Automation

[Marta Woźniak-Semeniuk]

Okay so we want JIRA to choose between CustomFieldDate and {{now.plusBusinessDays(10)} - whichever will come first?

[Laetitia Gascon]

exactly

[Marta Woźniak-Semeniuk]

Okay, so what I came up with is below.

1. I don't know what your trigger is so for my POC I made a transition a trigger just to check
2. Then I used IF-ELSE
3. in IF I check if my CustomDateField that I called"SLA date" comes before  10 days from now
4. =true - edit due date field to match my "SLA date" CustomDateField [I used smart value that gets the field input by CustomFieldId - I know the CustomFieldId from here "by url" https://confluence.atlassian.com/jirakb/how-to-find-id-for-custom-field-s-744522503.html"
5. if = false - edit date to match 10 days from now {{now.plusBusinessDays(10)}}

It works for me.