Automation in JIRA | Correct Timezone

[Mareli]

Hello All, 

I created this automation to update the summary when a field value changes:

I have managed to get the date format the way I want it but I am struggling to set the correct time in the summary. 

In the Automation the date field referees to customfield_12025 which is the "Start Date ann Time (DP)" field: 



As you can see the time is set to 2:30 PM.

But when I trigger the Automation the wrong time comes up, the time reads 12:30 instead of 14:30 or 2:30 PM:



I've tried the following to get the correct time:

1. {{issue.customfield_12025.format( "EEE, dd MMM yyyy HH:mm 'CAT'").convertToTimeZone(SAST)}}
2. {{issue.customfield_12025.format( "EEE, dd MMM yyyy HH:mm 'SAST'").convertToTimeZone(SAST)}}
3. {{issue.customfield_12025.format( "EEE, dd MMM yyyy HH:mm").convertToTimeZone(SAST)}}
4. {{issue.customfield_12025.format( "EEE, dd MMM yyyy HH:mm").convertToTimeZone(CAT)}}
5. {{issue.customfield_12025.format( "EEE, dd MMM yyyy HH:mm 'CAT'")}}
6. {{issue.customfield_12025.format( "EEE, dd MMM yyyy HH:mm 'SAST'")}}

None of these seem to work they just leave out the date and time completely, like this:



Any advice?

[Trudy Claspill · Accepted solution]

Hello @Mareli 

I have two recommendations.

First try swapping the time zone conversion and format functions. Both apply to a date/time value, but with the current order you are trying to apply timezone conversion to a formatted string. Try this order:

{{issue.customfield_12025.convertToTimeZone().format()}}

Second, I don't think the codes you are trying for time zone conversion are valid. In the documentation for the time zone conversion function...

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

...there is a link to a document from which you can get the valid entries to use for all the time zones.

https://joda-time.sourceforge.net/timezones.html

I don't see SAST or CAT in that list.

[Mareli]

Hi @Trudy Claspill 

IT WORKED! 

Thanks so much:



I used this one: 
{{issue.customfield_12025.convertToTimeZone("UTC+02:00").format("EEE, dd MMM yyyy HH:mm")}}

[QASIM ALOUDAT]

Hello

@QASIM ALOUDAT 

I am expect the country must pay for local timezone

[Marc - Devoteam]

Hi @Mareli 

Could you try {{issue.customfield_12025.jiraDate}}

[Mareli]

Hello @Marc - Devoteam 

This one did not work it does not give me the time and also the format is not correct