Forum Discussion
u156531
Nov 09, 2023Brass Contributor
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
- Nov 10, 2023
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.
Rob_Elliott
Nov 10, 2023Silver Contributor
You could just use the Modified column.