Forum Discussion
SharePoint Lists do not accept date format from date picker (punctuation vs. dash as delimiter)
Hi All I have an odd scenario. I have a MS Lists, where I have a date column with a date picker, Whenever I use the date picker to chose a new date e.g. 10th July 2022, it suggests 10.07.2022...
I have have somewhat similar problem: The "normal" (but not very good) behavior seems to be, that when editing an item, the date field is initially presented correctly (with dashes), and when you click in the field it is transformed into dots while the picker is visbile. Then when selecting a date and closing the picker, it gets transformed back to dashes.
However: On some lists (not all) this transformation does not happen, and it insists on keeping the dots, resulting in the error "Wrong format" and not being able to save.
Has anybody else seen this behavior and have ideas for fixing it?
However: On some lists (not all) this transformation does not happen, and it insists on keeping the dots, resulting in the error "Wrong format" and not being able to save.
Has anybody else seen this behavior and have ideas for fixing it?
I just found the "solution" to the problem I described: When I change the list setting under Advanced Settings, Offline Client Availability to false, the date picker "works" again. Not so well as one could wish for (it still shows dots instead of dashes) but it is able to accept and convert the date to dashes.
See this link: https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-online-quot-enter-a-date-like-this-error-quot-message/m-p/3392957/highlight/true#M60118
See this link: https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-online-quot-enter-a-date-like-this-error-quot-message/m-p/3392957/highlight/true#M60118