Why are my custom field sync dates 1 day off?

Originally asked by Suzanne May on 10 July 2021 (original question)


I have Jira server to Jira server set up. I am syncing a custom field date in one to the custom field date in the other. For some reason when the dates are syncing they sync 1 day off.

example from system has date 12/3/2021 the to system has 12/2/2021.

How can I get them to sync exactly?

Outgoing(Target Start and end are from Portfolio Jira)

replica.customFields.“Target start” = issue.customFields.“Target start”

replica.customFields.“Target end” = issue.customFields.“Target end”

Incoming:(Created custom data picker field to match on this instance as Portfolio is not installed)

issue.customFields.“Target start”.value = replica.customFields.“Target start”?.value

issue.customFields.“Target end”.value = replica.customFields.“Target end”?.value


Comments:

Ariel Aguilar commented on 10 July 2021

Hi Suzanne,

It would be helpful to see the code you are using on the incoming rules for dates sync. Is it the same on both sides?

Kind regards,

Ariel

Suzanne May commented on 10 July 2021

Outgoing(Target Start and end are from Portfolio Jira)

replica.customFields.“Target start” = issue.customFields.“Target start”

replica.customFields.“Target end” = issue.customFields.“Target end”

Incoming:(Created custom data picker field to match on this instance as Portfolio is not installed)

issue.customFields.“Target start”.value = replica.customFields.“Target start”?.value

issue.customFields.“Target end”.value = replica.customFields.“Target end”?.value

Ariel Aguilar commented on 20 July 2021

Hi Suzanne,

The configuration is fine.

If you go to Administration -> System Info, you can see the system date as JIRA sees it. Is it correct? Is the timezone listed there correct?

If not, then probably the operating system date is wrong as well.

Then, Atlassian has reported something similar as you see here: https://community.atlassian.com/t5/Jira-questions/All-date-fields-entered-is-changed-to-1-1-day-earlier/qaq-p/1234657

Also, JIRA’s date/time may not have been updated after daylight savings has taken effect - this is generally an issue with older versions of JAVA. Please check this out and hopefully it helps:

https://confluence.atlassian.com/jirakb/jira-s-timestamp-doesn-t-match-the-system-time-125698093.html

Kind regards,

Ariel

Suzanne May commented on 21 July 2021

We checked Time zone. They are matching on both systems.

We check operating system date both are correct.

This issue seems isolated to only the custom fields above. All other dates are syncing fine.

We are now checking out the joda-time.jar file These versions are out of sync.

Suzanne May commented on 21 July 2021

Ok joda-time.jar file didn’t work… so now to checking Java.