3 votes
Accepted

Using date commands in calculated fields

Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). Try using ...
Ganesh Sanap - MVP's user avatar
2 votes

Change the default time zone and locale for new users

By default all your users see the time as it is formatted at the root site (SPWeb) level. These settings get set when the site collection is provisioned by the web application default time zone. ...
Gautam Sheth's user avatar
  • 30.9k
1 vote

SharePoint online : strange language behavior

According to your description, is this the only site that has this problem? I just went to test and didn't revert your problem. In it you mentioned that the default language of the French user's ...
Xuyan Ding's user avatar
1 vote
Accepted

Is there a time zone for Australia inside the Regional setting for the site collection

Australia does not have a time zone. It has five. Even on your screenshot one can clearly see 3 Australian time zones: Likely, you will need UTC+10 Canberra, Melbourne, Sydney since most of ...
Denis Molodtsov's user avatar
1 vote
Accepted

Change date settings in the Sharepoint Online Admin Centre to DDMMYY

Based on my research, we could not change date formatting in the SharePoint Admin Center, it is by design. I would suggest you submit a feedback via User Voice. Here is a similar case for reference: ...
EchoDu_MSFT's user avatar
  • 2,835
1 vote
Accepted

RegionalSettings.TimeZone.UTCToLocalTime will always return 01/01/0001 00:00:00

01/01/0001 00:00:00 is a blank date. You need to add context.ExecuteQuery() after regionalSettings.TimeZone.UTCToLocalTime(itemversion.Created).Value to submit the convertion operation. // ...
Baker_Kong's user avatar
  • 1,179
1 vote
Accepted

How do you create a sharepoint language templated site?

The url syntax suggests the 'en-us'-part is the path name to the collection. By default (at least in O365) i would be 'sites' like this: https://mytest.sharepoint.com/sites/MySubSite But in central ...
Morten K's user avatar
  • 1,229
1 vote

SP2013 calendars are starting with Tuesday even after changing the Regional Settings

In the Regional settings, make sure the Locale is set correctly and the Time Zone matches user’s computer. If the issue exists, try to start->Run ->IISRest and check again.
Hellofiona_MSFT's user avatar
1 vote

Date Format On SharePoint 2013 Reports

You should be aware of the Reporting Services uses the locale settings based on the report server operating system. And to can show date time format based on the SharePoint regional settings , you ...
Mohamed El-Qassas MVP's user avatar
1 vote

Format Date using CSR (dd.MM.yyyy)

There are 2 functions SharePoint provides making Date calculations and formatting a whole lot easier: GetDaysAfterToday() https://sharepoint.stackexchange.com/search?tab=votes&q=user%3a32871%...
Danny '365CSI' Engelman's user avatar
1 vote

Format Date using CSR (dd.MM.yyyy)

Here the script: <script type="text/javascript" src="/_catalogs/masterpage/Somnio/js/moment.js"></script> <script type="text/javascript"> SP.SOD.executeFunc("clienttemplates.js", "...
Patrick's user avatar
  • 3,203
1 vote
Accepted

Update TimeZone Regional Settings in Office 365 using Powershell

The answer is to set TimeZone as a TimeZone: $ctx.Load($ctx.Web) $ctx.Load($ctx.Web.RegionalSettings.TimeZone) $ctx.Load($ctx.Web.RegionalSettings.TimeZones) $ctx.ExecuteQuery() $ctx.Web....
grisha's user avatar
  • 2,445
1 vote

Change Default Locale Settings for Site Collection in SharePoint Online

8 years later and Microsoft still haven't addressed proper locale support in SharePoint. Even with a site's locale set, it has hardcoded MM/DD/YYYY all over the place: document library restore ...
Mike Williams's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible