Apr 06 2021 10:47 AM
Apr 06 2021 10:47 AM
I have a SharePoint list where employees create a new item and fills out a form and submits it. I'm having problem with a date column though. Users have the correct access to this list and are using the date picker yet still receiving this error message.
Is there a different kind of access that I need to check?
Apr 08 2021 06:04 AM
Apr 28 2021 08:48 AM
Apr 28 2021 08:58 AM
I did not. I just deleted the date column and started using a single line text column instead :|
If you figure it out, please reply back here
Aug 12 2021 03:11 AM
Someone, please find a solution to this! A colleague asked me yesterday to look at it, as she was having trouble using the date picker when adding a new item in a SP list. I did not have the same problem, and tried various solutions with no luck. Regional settings in SP, on the computer, in Office, Sharepoint Admin settings ++. Today another colleague contacted me and experienced the same. However, now I also had this issue. Seriously..?!
Aug 12 2021 04:11 AM - edited Aug 12 2021 05:18 AM
Everything works fine when inputting new list element with the sharepoint mobile phone app. I then tried Edge browser (Chrome is my default), but same problem here with incorrect date format. Then, for the hell of it, I tried explorer. It had correct date format there! I then checked my Chrome regional setting and language, and everything seems fine...?! However, when I changed from Norwegian to Danish and relaunched Chrome, the date field in SP worked! Going back to Norwegian messed it up again. There must have been some error in the Chrome update with language packs and formats...??
Aug 17 2021 05:53 AM
Mar 22 2022 06:35 AM
Apr 12 2022 04:53 AM
May 18 2022 05:21 AM
Hi guys, I think I found a solution.
We also struggled quite a lot with this issue, some users were able to enter the date, some were not no matter which browser they used or whatever browser/windows locale and language settings they had applied.
After some laborious debugging I found, that on the problematic machines, form validation requests were sent to address starting with localhost:42050 instead of XtenantX.sharepoint.com
The whole problem was a list setting hidden under "Advanced Settings -> Offline Client Availability", which as far as I can tell, somehow caches or syncs (the details are unknown to me and I don't care about them much) the list to the local computer which then results in a lot of requests heading the localhost way instead of to the Microsoft cloud servers and also the form validation was going on localhost which resulted in the date picker error message.
Strangely this synchronization was active for some users, which then had the date picker problem and for some not, which had everything working perfectly. The signalization about active sync is also not seen at all times, but can be found next to the list name:
Solution then is to just turn off the Offline Client Availability and all our users suddenly stopped having problems with the date picker validation:
May 24 2022 12:47 AM
Jun 09 2022 01:47 AM
Aug 18 2022 06:54 AM
Nov 28 2022 01:35 AM
Feb 09 2023 01:19 AM
@Hanne_Lauritzen The amazing thing is that this bug has been there for over a year and Microsoft doesn't fix such a huge bug messing with thousands of users around the world.
But thats the standard Microsoft way - create an amazing product and then mess up the last details making their products almost useless.
Feb 22 2023 09:31 AM
I changed Site Settings > Regional Settings > Locale from English (United States) to English (Canada) and problem started to appear. I changed back to English (United States) and this fixed it for me.