Trying to understand times in Jira using convertToTimeZone

james September 21, 2023

I'm creating an Automation when an issue is cancelled, whereby the most recent comment is included in an email to a team lead, along with the comment author and comment time. When I use:
{{issue.comments.last.created.mediumDateTime}}, the time is 12 hours out (likely UTC or GMT). As such, I need to convert it to my timezone, so I have been trying:
{{issue.comments.last.created.mediumDateTime.convertToTimeZone("Pacific/Auckland")}}

When I use this, the Automation succeeds, but the time is absent from the output.

How can I get the time the most recent comment was created, and in a user-readable, timezone-appropriate format?

2 answers

1 accepted

1 vote
Answer accepted
james September 21, 2023

I've discovered the answer to my question and am posting it here in case someone else comes across my question later. The date/time should be converted before being formatted, like the following:

{{issue.comments.last.created.convertToTimeZone("Pacific/Auckland").mediumDateTime}}

0 votes
Leonardo Rodriguez
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 15, 2025

When I was creating an automation rule to auto-comment an issue when it is created and added the date in this way "issue.comments.last.created.mediumDateTime.convertToTimeZone" it didn't work, after trial and error I discovered that using {{now}} works for this case:
"{{now.convertToTimeZone("America/Santiago").mediumDateTime}}"

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events