Jira automation email - can not manipulate with "statuscategorychangedate" field value

[Nicolay Subbota]

Hi!

I try to configure some email report based on manipulating with "statuscategorychangedate" field value, but looks like it does not work.

My email report is following:

Total issues that *too long* stuck: <b>{{lookupIssues.size}}</b>

{{#lookupIssues}}
• <a href="{{url}}">{{key}}</a> <b>{{summary}}</b> <font color="darkolivegreen">[{{issueType.name}}]</font>
Assignee: <b>{{assignee.displayName}}</b>
This issue stuck in <b>{{status.name}}</b> from <b>{{statuscategorychangedate.jiraDate}} {{statuscategorychangedate.longDate}} {{statuscategorychangedate}}</b> (<font color="red"><b>{{statuscategorychangedate.diff(now).prettyPrint}} {{statuscategorychangedate.diff(now).days}}</b></font>)
{{/}}

But only *pure* {{statuscategorychangedate}} is displaying, another manipulating with "statuscategorychangedate" field value does not work.

Automation

[Nicolay Subbota · Accepted solution]

Answer has been found in https://community.atlassian.com/t5/Jira-Software-questions/Automation-some-dates-are-not-handled-as-dates/qaq-p/1534402

 Status Category Changed Date was implemented as string rather than as a date/time field for some reason.  If you convert it first it should work:

{{issue.statuscategorychangedate.toDate.mediumDate}}

Last Viewed may have the same issue so try the same thing.