Error Microsoft list - change the dates.

Question

Good afternoon, guys. I have a problem with the dates in the Microsoft list. when introduced in from the dates between 01/12/2023 to 12/12/2023, the system changed those dates to November 01/11/2023 automatically.

Any idea why this is happening?

Answer 1

Dear Diego,

I can reproduce the issue in our environment and it seems to be a display issue in Microsoft Lists.

I'm afraid that the issue needs to be fixed by our related team directly.

If you aren't the administrator, I suggest you contact the administrator in your company and let him follow the steps in Get support - Microsoft 365 admin | Microsoft Learn to open a support ticket to our related team as soon as possible.

About admin roles in the Microsoft 365 admin center - Microsoft 365 admin | Microsoft Learn

How do I find my Microsoft 365 admin? - Microsoft Support

The administrator should be able to open the support ticket from Help & support in the Microsoft 365 admin center.

Then you can select the Phone support or the Email support as follows.

As a workaround at your side, I suggest you apply the JSON code as follows on the Date columns to see the result. In my environment, I apply the same code to Date1 and Date2.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json","elmType": "span","txtContent": "=getDate(@currentField)+'/' + if(getMonth(@currentField)==1,2,if(getMonth(@currentField)==2,3,if(getMonth(@currentField)==3,4,if(getMonth(@currentField)==4,5,if(getMonth(@currentField)==5,6,if(getMonth(@currentField)==6,7,if(getMonth(@currentField)==7,8,if(getMonth(@currentField)==9,10,if(getMonth(@currentField)==10,11,if(getMonth(@currentField)==11,12,if(getMonth(@currentField)==12,12,'N/A'))))))))))) + '/' + getYear(@currentField)"}

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator