Forum Discussion

u156531's avatar
u156531
Brass Contributor
Nov 09, 2023

Update date field to todays date in a list

I have a date field in my list. I need to update it to today's date if anything in the row changed. Can someone show me how to do this.   Thanks
PowerApps
  • ganeshsanap's avatar
    ganeshsanap
    Nov 10, 2023

    u156531 

     

    JSON Formatting way:

     

    You can use either of below SharePoint JSON column formatting for your modified column: 

     

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

     

    OR 

     

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

     

    Note: When using toLocaleDateString() operator, results vary based on user's locale.

     

    You can find the steps to apply JSON column formatting at: Use column formatting to customize SharePoint 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

u156531's avatar
u156531
Brass Contributor
thanks, How do I reformat it to mm/dd/yyyy
ganeshsanap's avatar
ganeshsanap
MVP
Nov 10, 2023

u156531 

 

JSON Formatting way:

 

You can use either of below SharePoint JSON column formatting for your modified column: 

 

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

 

OR 

 

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

 

Note: When using toLocaleDateString() operator, results vary based on user's locale.

 

You can find the steps to apply JSON column formatting at: Use column formatting to customize SharePoint 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources