Hi I am trying to sync a datetime field in Jira with a date field in zendesk (bi-directionally) since Zendesk doesnt support date time fields.
Ideally in the future I would like to sync the “Time” portion as maybe a text field in zendesk but for now I just want the date to set the datetime in JIRA (I am okay if it always sets a default time as long as the date is correct)
Its currently syncing back and forth but for some reason the datetime value in Jira is the day before the date in zendesk.
Syncing from Jira to zendesk sets the proper date value but syncing from zendesk to Jira doesnt.
For example,
Date in Zendesk is changed to 16/Jul/20
DateTime in JIRA = 15/Jul/20 5:00 PM
Comments:
André Leroy-Beaulieu Castro commented on 01 September 2020
Hi Spencer,
Could it be that the date internally in Jira is in a different timezone than zendesk? Because the datetime is sent as a timestamp and the Jira interprets it according to it’s timezone, so if there’s an hours difference that makes it seem like its the day before in Jira then that’s how it will be set.
Thanks,
André
Spencer Johnson commented on 08 October 2020
André Leroy-Beaulieu Castro I got the fields working but I am trying to convert a string date in EST time to a date (timestamp) in PST time but am running into issues
Do you know how to convert a string representing a date (ie. ‘2020-10-25-11:45:00’) in EST to a timestamp in PST so I can set it in JIRA.