📁

SharePoint DD/MM/YYYY

輸出: 15/01/2025

快速參考

輸出

15/01/2025

在SharePoint中將日期格式化為DD/MM/YYYY

📁 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")