Forum Discussion

u156531's avatar
u156531
Brass Contributor
Nov 09, 2023
Solved

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
Nov 10, 2023
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.

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Nov 10, 2023

    u156531 

     

    As suggested, you can use the SharePoint default Modified column.

     

    You can set the date format using 2 ways: Using SharePoint default settings and JSON formatting.

     

    SharePoint default settings:

    1. Go to your SharePoint list
    2. Click on Settings (gear) icon at the top right corner and select List settings
    3. Scroll down to Columns section on list settings page and click on Modified column
    4. Set display format to Standard and click OK to save the column settings changes: 

    Output: 

    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's avatar
    Rob_Elliott
    Silver Contributor
    Nov 10, 2023

    u156531 go to Site Contents, then select Site Settings and in the settings page that appears select Regional Settings over on the left and change the time zone and locale settings.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

Resources