Convert date/time field to date field with especific TimeZone

Angel_wk2d0j

Hi

 

We need to register in issue the endDate of sprint in date field, Im using  a automation rule with webhook value "{{webhookData.sprint.endDate}}" but it save with UTC format, How I would save the webook value with my time zone in my date field? I tried with math expresion "{{webhookData.sprint.endDate.minusHours(6)}}" and with convert function too but didnt work, the value that returns is empty.

We are in Jira Software-Cloud

Thanks

Best regards

 

 

Bill Sheboy

Hi @Angel 

The data from the webhookData is likely text, and must be converted with toDate before using with date / time functions:

https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/#Converting-text-to-dates

 

And after conversion, I suggest using the built-in conversion functions for time zones: 

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

 

Kind regards,
Bill