Smart Value to set a date based on a date passed from Salesforce

Kelly Bates

We have a sync set up to pass a date value for "Expected Delivery Date" from a Salesforce ticket into Jira. When it hits Jira, I want the date to be set based on the date value sent from Salesforce minus 4 business days. I'm using Automation and this smart value: {{[date].minusBusinessDays(4)}}

Automation Steps:

When: Value Changes for "Expected Delivery Date"

Then: Edit work item fields "Expected Delivery Date" by setting the field value as {{[date].minusBusinessDays(4)}}

However, it's not working. What am I missing?

Bill Sheboy

Hi @Kelly Bates 

For a question like this, context is important for the community to help.  Please post the following:

• what type of project is this: company-managed, team-managed, JPD, etc.
• an image of your complete automation rule in a single image for continuity
• images of any relevant actions / conditions / branches
• an image of the audit log details showing the rule execution
• explain what is not working as expected and why you believe that to be the case

Until we see those...

Without seeing your rule, I can think of two things to check:

Smart values are name, spacing, and case-sensitive, and the often do not match the field name on the Jira pages.  When an incorrect one is used, that returns as null, and often fails to work without showing an error.  To confirm the correct smart value (or custom field ID) for your field, please use this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Next, what is the type of your field?  If it is text, rather than a date picker, you may need to convert the value to a date first using the toDate function: https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/#Converting-text-to-dates

 

Kind regards,
Bill