I have two questions in regards time stamp in SharePoint online:

  1. If someone change the regional settings under his or her account what would be the difference? For instance in site collection the regional setting has been set for Singapore and someone using the same SharePoint environment but lives in Germany?
  2. If I create a date column, would the date be different in different countries with different time zones?

1 Answer 1


All dates are stored as UTC in SharePoint and displayed according to the regional settings of your SharePoint site.

  • Thanks Callum. Do you know if the users change the time preference in Delve or Office365? Does this affect SharePoint?
    – Harris
    Commented Sep 19, 2022 at 0:35
  • The date is shown according to the regional settings of the individual SharePoint site, I don't believe anything will else will override that setting. Commented Sep 20, 2022 at 7:10
  • Thanks again for your message, does this means if I live in the US and someone else lives in China and we are using the same SharePoint site, and the regional settings are set to the US, the user in China will see the local time under the date column?
    – Harris
    Commented Sep 21, 2022 at 3:14
  • It would appear as the US time, is my understanding. Commented Sep 21, 2022 at 19:10
  • According to Microsoft, users can change their time zone under their profile which will over right the site collection time zone. We have done that; however, all the time zones remain the same. Thanks again.
    – Harris
    Commented Sep 23, 2022 at 1:55

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.