Date Error in Microsoft List

Question

I keep receiving this kind of error the next day after creating the date column in Microsoft List.
the date looks weird and when I click it, it shows an error message.

Answer 1

Dear kuaci,

Thanks for sharing updates with us and we really appreciate your effort and your precious time doing those tests. 

We've also done a quick test to create list from Excel, change the column type and wait for the next day to see the outcome, however, we cannot reproduce a similar situation on our side.

Considering that issue happens to all Lists that you created and new list saved to Teams Channel got the same error, issue could be related to your account or the tenant background service which need to be checked from the backend.

As forum support, we may not have enough permission and resource to directly check the backend environment.

In this situation, we sincerely recommend you contact your Microsoft 365 administrator, follow steps in this article to create a support ticket with Online Support. The support team over there has higher permission than us, they can remotely help check the situation on your side, involve more resource to collect logs and help you do troubleshoot. This would be a more efficient way in handling this case for you.

For reference: How do I find my Microsoft 365 admin?

Thanks for your understanding and cooperation! Have a good day.

Sincerely,

Rhoda | Microsoft Community Moderator

Answer 2

Hi Rhoda,

Thanks for your response.

1. I created List from Excel and only changed the column type. for the date column, I changed the column type from number to date and time. I got no issue when the import process from excel is finished, the date column is fine. but the next day when I open the list again, the issue happened. I just start using Microsoft List this week, so I don't do any advanced settings.
2. The issue happen to all Lists that I created. I save it to "My List", and then tried to create a new one and save it to Teams Channel but still got the same error.
3. It seems only to affect the List that I created.

I also changed the region setting in List and SharePoint site setting to my region, Indonesia.

Answer 3

Dear kuaci,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, it seems that error prompts in the Micrsoft List the next day after creating the date column, and the date format looks weird.

If the understanding above is right, we've done search based on the error message you are getting, and we get "Too many re-renders. React limits the number of renders to prevent an infinite loop." from reactjs.org. We'd recommend you create a new list and add the said column again to check the outcome.

At meantime, please also provide the information below for a better understanding of the situation:

1. May I know if you have customized the column or list? If yes, please share your steps with us.
2. Does the issue happen when you open this specific list or different lists? Where are the lists saved?
3. What about the other users in your organization, will they encounter a similar situation within this specific list? What about the other lists on their side?

Looking forward to your reply, please notice the above information is vital for us to further assist you, any updates please feel free to post back.

Your understanding and patience will be highly appreciated. We hope that you are keeping safe and well!

Sincerely，

Rhoda | Microsoft Community Moderator