One for sharepoint gurus

[Nicetobenice]

I've recently set up a small business to use office 365

I created a sharepoint list to handle enquiries and fundamentally it's working and is sufficient for current needs

However for some reason the sharepoint had a default of US pacific time and date settings. No idea why as nowhere else had this setting

I've rectified the default setting but cannot for the life of me work out how to change the setting in the list. I've even created a new list and Imported the data again. When I click the settings wheel there isn't an option to change


Any bright ideas?

[redstar1]

In the Sharepoint site, click the settings gear, site settings, regional settings (under stie administration) and you can change the time zone there.

[Nicetobenice]

redstar1 said:

In the Sharepoint site, click the settings gear, site settings, regional settings (under stie administration) and you can change the time zone there.

I've done that
Doesn't seem to change the existing list

[eeLee]

If you need a quick column-level fix

You can force UK format using JSON formatting:

Click column → Column settings → Format this column
Paste:
{
"elmType": "div",
"txtContent": "=toLocaleDateString(@currentField,'en-GB')"
}
💡 One extra gotcha

If your dates were entered as text (not true Date columns), changing region won’t fix them—you’d need to convert the column type or clean the data.

[Nicetobenice]

eeLee said:

If you need a quick column-level fix

You can force UK format using JSON formatting:

Click column ? Column settings ? Format this column
Paste:
{
"elmType": "div",
"txtContent": "=toLocaleDateString(@currentField,'en-GB')"
}
? One extra gotcha

If your dates were entered as text (not true Date columns), changing region won t fix them you d need to convert the column type or clean the data.

Thanks
Gave this a go but got

toLocaleDateString(@currentField,'en-GB'

In every field

Will have another look in the morning