How to I set a SharePoint List column to Today's date? Anytime and item is modified, I want to set a column to today's date.
I have not been able to get this to work.
Solved! Go to Solution.
I ended up using this expression "formatDateTime(utcNow(),'yyyy-MM-dd')" when I update the item, and it seems to be working fine.
Hello @Spawn10 ,
do you need a separate column for that? There's already default 'Modified' date column in SharePoint that contains the date/time of the last update.
I ended up using this expression "formatDateTime(utcNow(),'yyyy-MM-dd')" when I update the item, and it seems to be working fine.
Where should I write this formula? When creating a date column?
@tom_riha How do I achieve that? I am defining a separate column for modified dates. When there is a change in any of the values of the column, then I would like the list to take the current date automatic on date column
Hello @Ravi021 ,
if it's about storing the date of last modification then you can use the standard SharePoint "Modified" column. You don't need an extra one.
I only see a date/time column. I do not see a default for a 'modified' column.
Where do you insert that expression?