Wrong time zone and date format

%3CLINGO-SUB%20id%3D%22lingo-sub-144377%22%20slang%3D%22en-US%22%3EWrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-144377%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20noticed%20that%20for%20our%20tenant%2C%20all%20OneDrive%20for%20Business%20sites%20have%20US%20date%20format.%20I%20am%20versed%20in%20SharePoint%2C%20so%20I%20know%20to%20go%20to%20Site%20Settings%20and%20change%20the%20regional%20settings.%20But%20that's%20just%20me.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20an%20administrator%2C%20I%20need%20to%20change%20all%20of%20our%20user%20sites%20to%20NZ%20region%20and%20language.%20Note%20that%20we%20sync%20from%20local%20AD%2C%20but%20the%20language%20field%20in%20AD%20is%20blank.%20I%20assume%20that%20means%20that%20the%20tenant%20default%20language%20and%20region%20is%20applied.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQuestions%3A%3C%2FP%3E%0A%3CP%3E1.%20Where%20can%20I%20set%20the%20%3CSTRONG%3Edefault%3C%2FSTRONG%3E%20region%20and%20language%20for%20the%20%3CSTRONG%3Etenant%3C%2FSTRONG%3E%2C%20so%20that%20new%20users%20get%20correct%20OD4B%20settings%20for%20my%20country%3F%3C%2FP%3E%0A%3CP%3E2.%20How%20can%20I%20most%20efficiently%20change%20%3CSTRONG%3Eall%20existing%3C%2FSTRONG%3E%20OD4B%20sites%20in%20our%20tenant%20to%20the%20correct%20region%20and%20time%20zone%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-144377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-395108%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-395108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F314342%22%20target%3D%22_blank%22%3E%40RuthJ%3C%2FA%3E%26nbsp%3B%20Thanks%20for%20posting%20that.%20I%20wasn't%20aware%20of%20this%20setting.%26nbsp%3B%20Do%20you%20know%20if%20it%20applies%20to%20new%20OneDrive%20for%20Business%20sites%2C%20too%3F%20Because%20the%20fine%20print%20says%20that%20it%20applies%20%22when%20you%20create%20a%20new%20modern%20site%22.%20And%20time%20zone%20is%20just%20one%20thing.%20The%20region%20is%20the%20other%20setting%20that%20needs%20adjusting%2C%20so%20the%20date%20is%20displayed%20in%20the%20correct%20order%20(DMY%20vs%20MDY).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394764%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EA%20year%20late%20maybe%2C%20but%20looks%20like%20there%20is%20now%20a%20(partial)%20Tenancy%20wide%20solution%20now%20for%20the%20Timezone%20problem.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsympmarc.com%2F2018%2F09%2F14%2Fset-default-site-time-zone-in-office-365%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsympmarc.com%2F2018%2F09%2F14%2Fset-default-site-time-zone-in-office-365%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166623%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166623%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20believe%20that%20there%20is%20a%20world%20of%20Office%20365%20users%20out%20there%2C%20all%20around%20the%20globe%2C%20whose%20OneDrive%20defaults%20to%20US%20regional%20settings.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166262%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166262%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20but%20there%20is%20no%20way%20to%20do%20this%2C%20it%20is%20quite%20annoying.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147243%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147243%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20but%20I%20already%20know%20that.%20The%20link%20you%20posted%20is%20about%20SharePoint.%20My%20question%20is%20about%20OneDrive%20for%20Business%20(yes%2C%20I%20know%2C%20that's%20SharePoint%2C%20too)%2C%20at%20the%20TENANT%20level.%20How%20can%20I%20set%20the%20default%20time%20zone%20at%20the%20tenant%20level%2C%20so%20that%20new%20users'%20OneDrives%20get%20the%20correct%20time%20zone%20by%20default%20and%20I%20don't%20have%20to%20manually%20set%20it%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-146773%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-146773%22%20slang%3D%22en-US%22%3E%3CP%3EPowerShell%20is%20the%20best%20option%20for%20people%20who%20enjoy%20writing%20code.%20It%20is%20much%20easier%20to%20change%20a%20setting%20in%20SharePoint%20by%20simply%20going%20to%20the%20appropriate%20settings%20page%20than%20trying%20to%20write%20a%20PowerShell%20script.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2Fsharepoint-time-zone%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepointmaven.com%2Fsharepoint-time-zone%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-145371%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145371%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20I'll%20take%20a%20look%20at%20that.%20It's%20astounding%2C%20though%2C%20that%20this%20is%20so%20hard%20to%20do%2C%20i.e.%20not%20possible%20with%20the%20Office%20Admin%20GUI.%20Or%20am%20I%20missing%20something%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20Powershell%20the%20ONLY%20way%20to%20set%20the%20region%20and%20time%20zone%20for%20a%20single%20region%20tenant%20who%20is%20not%20in%20the%20US%3F%20How%20do%20US%20businesses%20on%20the%20East%20cost%20change%20from%20the%20default%20Pacific%20time%20to%20their%20time%20zone%3F%20Is%20Powershell%20really%20the%20only%20option%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESurely%2C%20Microsoft%20can't%20expect%20everyone%20to%20default%20to%20a%20US%20setting.%20Why%20do%20they%20make%20it%20so%20hard%20to%20apply%20non-US%20as%20a%20tenant%20setting%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-144390%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-144390%22%20slang%3D%22en-US%22%3EPowerShell%20is%20your%20best%20friend%20here...I%20think%20you%20can%20solve%20both%201.%20and%202.%20following%20what%20it's%20described%20here%3A%20%3CA%20href%3D%22http%3A%2F%2Fmsexperttalk.com%2Fconfiguring-office-365-preferred-language-settings%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fmsexperttalk.com%2Fconfiguring-office-365-preferred-language-settings%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1211198%22%20slang%3D%22en-US%22%3ERe%3A%20Wrong%20time%20zone%20and%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1211198%22%20slang%3D%22en-US%22%3EI%20realise%20this%20post%20if%20a%20year%20old%20but%20just%20wanted%20to%20confirm%20that%2C%20after%20we%20changed%20the%20default%20time%20zone%20in%20SPO%20admin%20center%2C%20newly%20provisioned%20user%20accounts%20have%20their%20OneDrive%20in%20that%20time%20zone%20(GMT%2B1%20for%20us).%3C%2FLINGO-BODY%3E
Highlighted
MVP

Hello,

 

I've noticed that for our tenant, all OneDrive for Business sites have US date format. I am versed in SharePoint, so I know to go to Site Settings and change the regional settings. But that's just me.

 

As an administrator, I need to change all of our user sites to NZ region and language. Note that we sync from local AD, but the language field in AD is blank. I assume that means that the tenant default language and region is applied.

 

Questions:

1. Where can I set the default region and language for the tenant, so that new users get correct OD4B settings for my country?

2. How can I most efficiently change all existing OD4B sites in our tenant to the correct region and time zone?

9 Replies
PowerShell is your best friend here...I think you can solve both 1. and 2. following what it's described here: http://msexperttalk.com/configuring-office-365-preferred-language-settings/
Highlighted

Thanks, I'll take a look at that. It's astounding, though, that this is so hard to do, i.e. not possible with the Office Admin GUI. Or am I missing something?

 

Is Powershell the ONLY way to set the region and time zone for a single region tenant who is not in the US? How do US businesses on the East cost change from the default Pacific time to their time zone? Is Powershell really the only option?

 

Surely, Microsoft can't expect everyone to default to a US setting. Why do they make it so hard to apply non-US as a tenant setting?

Highlighted

PowerShell is the best option for people who enjoy writing code. It is much easier to change a setting in SharePoint by simply going to the appropriate settings page than trying to write a PowerShell script.

 

https://sharepointmaven.com/sharepoint-time-zone/

 

Highlighted

Thanks but I already know that. The link you posted is about SharePoint. My question is about OneDrive for Business (yes, I know, that's SharePoint, too), at the TENANT level. How can I set the default time zone at the tenant level, so that new users' OneDrives get the correct time zone by default and I don't have to manually set it??

Highlighted

Sorry but there is no way to do this, it is quite annoying. 

Highlighted

I can't believe that there is a world of Office 365 users out there, all around the globe, whose OneDrive defaults to US regional settings.

Highlighted

@Ingeborg Hawighorst 
A year late maybe, but looks like there is now a (partial) Tenancy wide solution now for the Timezone problem.

https://sympmarc.com/2018/09/14/set-default-site-time-zone-in-office-365/

Highlighted

@RuthJ  Thanks for posting that. I wasn't aware of this setting.  Do you know if it applies to new OneDrive for Business sites, too? Because the fine print says that it applies "when you create a new modern site". And time zone is just one thing. The region is the other setting that needs adjusting, so the date is displayed in the correct order (DMY vs MDY).

Highlighted
I realise this post if a year old but just wanted to confirm that, after we changed the default time zone in SPO admin center, newly provisioned user accounts have their OneDrive in that time zone (GMT+1 for us).