It seems the SP data repository and front-end SP list use two different timezones. when I get a date from version history it is different from what is actually shown in the SP list, how can I fix this?

Below is the sample, "was" is coming from the data repository through version history API (_api/web/lists/getbytitle('')/items()/versions?$top=1), and "is" from the sp list through triggerbody().

enter image description here

1 Answer 1


SharePoint stores dates in UTC, which are then converted to whatever time zone you have set for your site. In this case your date in UTC is the 27th but in your time zone is the 28th.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.