Migrating Datetime fields #2732
-
|
Hello, when migrating Datetime fields, I observed that the time is changed by 1 hour, it looks as if the source and target work items are on different time zones. I have already checked the regional settings on the server that runs migration tools. What could cause this behavior? Thank you |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
|
Hmm... no idea. All our code works in UTC and TFS/ADO provides data through the API's in UTC. |
Beta Was this translation helpful? Give feedback.
-
|
Hello, my team investigated and eventually discovered that data is consistently stored in UTC. The observation that times were different in source and target organization was caused by user settings, it was a visualization problem. A user can have a time zone configured in the source organization and a different time zone, by default UTC, in the target organization. After setting the same time zone in the target organization for the user, the times appeared to be the same. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for comming back with the answer. |
Beta Was this translation helpful? Give feedback.
Hello, my team investigated and eventually discovered that data is consistently stored in UTC. The observation that times were different in source and target organization was caused by user settings, it was a visualization problem. A user can have a time zone configured in the source organization and a different time zone, by default UTC, in the target organization. After setting the same time zone in the target organization for the user, the times appeared to be the same.
We started to explore if there are any APIs to try to migrate this setting.