Microsoft Lists column date format

Question

I have created a list in SharePoint with the Lists app and imported the data from Excel. This list has a date column with dates which look like 'February 23 2021 (friendly format). I would like it to appear in dd/mm/yy or dd/mm/yyyy format e.g. 23/02/2021. I understand that some JSON code would make this work - but I am unable to get it right. Is there a simple piece of JSON code that does this?

Answer 1

Hi Mark_Reynolds_1066,

Thanks for your valuable feedback, glad to know that my replies helped you.

Comments and feedback from our customers really motivate us to perform better and better and provided as much help as possible.

I appreciate your kind words.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Sincerely, 

Waqas Muhammad

Answer 2

Dear Mark_Reynolds_1066,

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

As per your description, please let us cooperate and please don’t worry, we can work together to narrow down and resolve the situation.

Based on my test, to display the SharePoint date format as dd/MM/yyyy, the JSON code, below can work:

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": {
        "operator": "toLocaleDateString()",
        "operands" : ["@currentField"]
    }
}

Result:

Also, to display the SharePoint date format as dd/MM/yyyy, you can also use the SharePoint calculated column instead of using JSON column formatting:

Steps:

1.Create a new calculated column with the below formula to format date with

2.Click OK, then go back to your List, you should note that the Date column format is now displaying in dd-MM-yyyy as below.

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

Sincerely, 

Waqas Muhammad

Answer 3

Thanks a lot, Waqas. It works perfectly. I am very grateful.

Mark

Answer 4

Hi Mark_Reynolds_1066,

If you find our suggestions helpful, you can also use the feedback tool below our reply to submit your feedback for us (pictured below), which will definitely help others in the community who are experiencing similar problems to find solutions to their problems more quickly.

Have a great day!

Best wishes

Waqas Muhammad