Date is of by 60 days...

[Romeo Bollen]

I created an automation to display a date in tickets that are automaticly created.

{{now.convertToTimeZone("Europe/Rome").format("YYYY-MM-DD")}}

It translates it into  2024-03-75 ?

We are the 15th, I've never experienced a 75+ day month on this planet.

Anybody any clues on what went wrong?

[Kishan Sharma · Accepted solution]

Hi @Romeo Bollen 

It appears that the format may not be correct. You can try below:

{{now.convertToTimeZone("Europe/Rome").format("yyyy-MM-dd")}}

[Romeo Bollen]

Thank you for the correction.

[Bill Sheboy · Accepted solution]

Hi @Romeo Bollen 

That is showing the day-of-year ("D"), and not the day-of-month ("d").

When looking at the documentation for automation functions, they often also provide links to the supporting materials.  In this case, there is also a link to the Java documentation which shows the possible format layouts / characters.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-format---

https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html

Kind regards,
Bill

[Romeo Bollen]

Thank you for the full explanation.