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?
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}}
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}}"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.