When managing mailboxes in Exchange Online, especially in multinational organizations, setting the correct regional settings is critical. One of the cmdlets used for this is Set-MailboxRegionalConfiguration. However, administrators often encounter errors related to incorrect DateFormat and TimeFormat settings.
Common Errors
When running Set-MailboxRegionalConfiguration, you might see errors similar to these:
Ex328A48|Microsoft.Exchange.Data.DataValidationException|DateFormat "dd/MM/yyyy" isn't valid for current language setting "en-US". Valid formats include "M/d/yyyy, M/d/yy, MM/dd/yy, MM/dd/yyyy, yy/MM/dd, yyyy-MM-dd, dd-MMM-yy".
Or:
Ex402B93|Microsoft.Exchange.Data.DataValidationException|The TimeFormat "h:mm tt" isn't valid for current language setting "da-DK". Valid formats include "HH:mm, H:mm".
Why Do These Errors Occur?
These errors happen when the DateFormat or TimeFormat you set does not match what is allowed for the selected language (Locale) of the mailbox.
Here are some examples:
United States (en-US):
- Expected DateFormat:
MM/dd/yyyy - Expected TimeFormat:
h:mm tt(e.g., 2:30 PM)
United Kingdom (en-GB):
- Expected DateFormat:
dd/MM/yyyy - Expected TimeFormat:
HH:mm(24-hour clock)
Denmark (da-DK):
- Expected DateFormat:
dd-MM-yyyy - Expected TimeFormat:
HH:mm(24-hour clock)
Germany (de-DE):
- Expected DateFormat:
dd.MM.yyyy - Expected TimeFormat:
HH:mm(24-hour clock)
Spain (es-ES):
- Expected DateFormat:
dd/MM/yyyy - Expected TimeFormat:
H:mm(24-hour clock)
France (fr-FR):
- Expected DateFormat:
dd/MM/yyyy - Expected TimeFormat:
HH:mm
Netherlands (nl-NL):
- Expected DateFormat:
dd-MM-yyyy(e.g., 28-04-2025) - Expected TimeFormat:
HH:mm(24-hour clock)
How to Localize the Mailbox Using a Simple UI
With EasyEntra, first-level support teams can easily view and configure the mailbox localization.
The setting is available on any mailbox-enabled hybrid or cloud-only user account: Simply, open user properties and go to the Mailbox tab.
Changing the mailbox regional settings will require a restart of OWA/Outlook before the menu items change to the new language setting.
A change in the folder localization takes place immediately as seen here:
PowerShell Alternative (Not Optimal for First-Level Support)
If you prefer using PowerShell, use the following PowerShell commands to set the correct DateFormat and TimeFormat on the mailbox.
Example for US:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "en-US" -DateFormat "MM/dd/yyyy" -TimeFormat "h:mm tt"
Example for UK:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language" "en-GB" -DateFormat "dd/MM/yyyy" -TimeFormat "HH:mm"
Example for Germany:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "de-DE" -DateFormat "dd.MM.yyyy" -TimeFormat "HH:mm"
Example for Spain:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "es-ES" -DateFormat "dd/MM/yyyy" -TimeFormat "H:mm"
Example for France:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "fr-FR" -DateFormat "dd/MM/yyyy" -TimeFormat "HH:mm"
Example for Netherlands:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "nl-NL" -DateFormat "dd-MM-yyyy" -TimeFormat "HH:mm"
Using the -LocalizeDefaultFolderName switch will update these folder names to match the new language settings.
Default system folders that are renamed:
Inbox
Sent Items
Drafts
Deleted Items
Junk Email
Outbox
Calendar
Contacts
- “Inbox” becomes “Indbakke”
- “Sent Items” becomes “Sendt post”
- “Inbox” becomes “Boîte de réception”
- “Sent Items” becomes “Éléments envoyés”
- “Inbox” becomes “Posteingang”
- “Sent Items” becomes “Gesendete Elemente”
- “Inbox” becomes “Bandeja de entrada”
- “Sent Items” becomes “Elementos enviados”
- “Inbox” becomes “Postvak IN”
- “Sent Items” becomes “Verzonden items”
Example for Denmark:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "da-DK" -DateFormat "dd-MM-yyyy" -TimeFormat "HH:mm" -LocalizeDefaultFolderName
Example for France:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "fr-FR" -DateFormat "dd/MM/yyyy" -TimeFormat "HH:mm" -LocalizeDefaultFolderName" -TimeFormat "HH:mm"
Example for Germany:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "de-DE" -DateFormat "dd.MM.yyyy" -TimeFormat "HH:mm" -LocalizeDefaultFolderNamee
Example for Spain:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "es-ES" -DateFormat "dd/MM/yyyy" -TimeFormat "H:mm" -LocalizeDefaultFolderName
Example for Dutch:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "nl-NL" -DateFormat "dd-MM-yyyy" -TimeFormat "HH:mm"
Example for UK:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "en-GB" -DateFormat "dd/MM/yyyy" -TimeFormat "HH:mm" -LocalizeDefaultFolderName
Example for US:
Set-MailboxRegionalConfiguration -Identity "user@domain.com" -Language "en-US" -DateFormat "MM/dd/yyyy" -TimeFormat "h:mm tt" -LocalizeDefaultFolderName
This ensures that the user’s mailbox folders are properly localized, providing an optimal experience for the end user.
Conclusion
Correctly setting mailbox regional configurations is crucial for user satisfaction and operational efficiency. Using EasyEntra’s graphical interface makes it fast and error-free, while PowerShell remains a more advanced method for skilled admins.
By using EasyEntra, even first-level supporters without PowerShell skills can resolve regional settings issues quickly and accurately. This empowers a broader range of IT staff to handle tickets independently, reduces escalation rates, and leads to faster resolution times for end users.
In contrast, relying solely on PowerShell requires technical expertise and increases the risk of errors when configuring settings manually.
