Convert date/time field to date field with especific TimeZone

[Angel]

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 · Accepted solution]

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

[Angel]

Thanks @Bill Sheboy