📁

SharePoint Date Format DD/MM/YYYY

Output: 15/01/2025

Quick Reference

Output

15/01/2025

Format Date as DD/MM/YYYY in SharePoint

📁 SharePoint

// In column formatting JSON:
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=toLocaleDateString(@currentField, 'en-GB')"
}

// Or in calculated column:
=TEXT([DateColumn],"dd/mm/yyyy")