JSON code to display date in dd/mm/yyyy format without time in sharepoint

Question

I have SharePoint List in a modern experience SharePoint online site and I want to use JSON column formating to display the date in dd/mm/yyyy format without time in SharePoint List.

I've tried using toLocaleDateString() and toDateString() to show date as dd/mm/yyyy but still do nothing

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=Date(@currentField,toDateString())"
}

Is it possible to format the date column in dd-MM-yyyy using JSON column formatting?

Answer 1

How to display Date column format in dd-MM-yyyy using JSON column formatting?

To display the SharePoint date format as dd/MM/yyyy, you should use the SharePoint calculated column instead of using JSON column formatting as the following:

Steps:

1. Open your SharePoint List > At all items > click on Add new column > More.
   

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

    =TEXT(Start,"dd/MM/yyyy")
   

3. The final calculated column setting should look like the below image.
   
   4.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.
   

Note: You can now apply your JSON code formatting on the newly created SharePoint Calculated Column as you prefer.

---

See Also

• JSON SharePoint Date Column Formatting in SharePoint 2019 and SharePoint Online
• Use column formatting to customize SharePoint
• If Else JSON SharePoint Column Formatting?