Default value date and time not displaying in my SharePoint lists

Question

None of my SharePoint lists are pulling in the current date and time when i set the default value as "todays date" The section is blank. Almost as if the SharePoint site is unable to locate the date a rime from anywhere. I have tried the regional settings in the SharePoint site but that has made no difference. I have set it to a different region and then set it back to London etc

It also doesn't work if I use the calculated value and use =NOW() - Same issue just a blank box. it was working for a week prior to this bug displaying.

I think that SharePoint is not locating the current time from our region some of the users are reporting that they are 2 hours ahead of the time Zone when looking at their contact card on team.

this site is not allowing me to set up a screenshot sorry.

Answer 1

I've also come across this problem today, both on a client SharePoint site and my own test SharePoint site. Based on some of the responses in this thread, I've tried various combinations of Time Zone and Locale. I'm based in the UK so my sites were correctly set as:

Time Zone: (UTC) - Dublin, London etc.

Locale: English (United Kingdom)

With these settings, calculated dates do not work. However, if I change the Time Zone to (UTC-08:00) Pacific, but keep the Locale as English (United Kingdom) the calculated fields work fine.

There is defintely something strange with SharePoint dates, as I also have an issue on my clients' SharePoint where dates in document libraries are one day behind, even through they show correctly in the document, regardless of changes to the timezone and locale settings. I have also checked the default site settings in the SharePoint Admin, and changed these back and forth, but this does not appear to make any difference.

Hope this helps someone, I am asking my client to raise a ticket with Microsoft to investigate.

Answer 2

I wanted to check in to see if there was a fix for this. We are experiencing this issue as of today, August 19, 2024.

Answer 3

I was able to get it to work, but it was a crappy workaround.

My columns are:

Date Acquired

Years

Endlife

When I edited the column in SharePoint, my calculation was as follows: =[Date Acquired]+[Years]. > Save. I went into lists and refreshed my list. I had to go into "Endlife" > column settings >format columns > format dates, and the calculation came up. My original "Years" column had to be converted to days (7 years = 2,555) to give me the ending date.

A crappy workaround, but it did the trick.