Automation error message for Data Format

Yaniv_5wopzn

On Cloud I have an automation to update Parent Target Start & End date according to their children.

The condition is passes but the Edit issue part is fails with this error message:

"Key-57 (The Target end must be of the format "yyyy-MM-dd" (customfield_10023), The Target start must be of the format "yyyy-MM-dd" (customfield_10022))."

 

Here is my date format settings in Admin

Here is the way the date value is displayed on an issue:

And this is the JSON I have under the Edit Issue block of the automation:

{
"fields": {
"Target Start": "{{llookupissues.Target Start.min}}",
"Target End": "{{llookupissues.Target End.max}}"

}
}

How can I fix it?

Bill Sheboy

Hi @Yaniv 

First, there are typographical errors in your smart values for {{lookupIssues}} references.  Smart values are name, spacing, and case-sensitive.  Incorrect values are returned as null.

Next, that error message tells you the values are in the incorrect format, and must be passed exactly as "yyyy-MM-dd" but passing just the date values sends them in a longer format.  

You may use the jiraDate format, as described here: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-format---

For example, please try this:

{
  "fields": {
    "Target start" : "{{lookupIssues.Target start.min.jiraDate}}",
    "Target end" : "{{lookupIssues.Target end.max.jiraDate}}"
  }
}

Kind regards,
Bill