How do I set a SharePoint list column to today's date

[Spawn10]

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.

[tom_riha]

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.

[Spawn10 · Accepted solution]

I ended up using this expression "formatDateTime(utcNow(),'yyyy-MM-dd')" when I update the item, and it seems to be working fine. 

[Ravi021]

Where should I write this formula? When creating a date column?

[Ravi021]

@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

[tom_riha]

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.

[tinalamkey]

I only see a date/time column.  I do not see a default for a 'modified' column.

[tinalamkey]

Where do you insert that expression?