Date Field Calculation

[Rich Douglass]

Hi,

I am evaluating JSM using the free edition. I created a form with custom fields and want to set the due date on a work item to be three days prior to the date of another field I called Start Date.

Using automation, I have the following, but it does not appear to work. What am I missing or is this the wrong approach for what I want to do?

{{issue.customfield_10015.minusBusinessDays(3)}}

This validates, but does not update the due date field for the work item. The automation is run on creation of the work item.

Thanks.

Rich.

[Trudy Claspill]

Hello @Rich Douglass 

Welcome to the Atlassian community.

Please show us screen images of your entire automation rule, and the details of the step where you are trying to set the "due date" field.

There are multiple problems that could be occurring.

"customfield_10015" may not be the correct reference for the Start Date field you are using.

To confirm you have the correct field id, use the guidance in the following document to view the data in an issue that has the Start date field set.

https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Search the output for the start date value you entered, and confirm that it corresponds to the custom field id you have used in your rule.

The "due date" field that you have specified in your Automation rule may not be the "due date" field in use in your project. Have you picked that field from the Choose fields to set list in an Edit action? Was there more than one field named 'due date"? Did you choose the one that matched the field label you see in the issues; i.e. "Due date" vs. "Due Date"?

You can use the same procedure above to view the data in an issue where your "due date" field has been set.

Is your "Start Date" field configured as a Date or Date/Time field or some other field type? Is it the same type as the "due date" field you're using?

[Nate Whitehead]

If you add a "Log Action" step with that value, what do you get in the log?