Help

Update date field automatically to TODAY, when another field is updated

135 1
cancel
Showing results for 
Search instead for 
Did you mean: 
OHB911
4 - Data Explorer
4 - Data Explorer

Hi,

I am trying to set a date field value to today's date, when another value for that record is updated. e.g. when status changes to X, set date field to today's date. I am simply looking for UK date format e.g. 23/01/2024 

Does anyone have any ideas? Thank you in advance.

 

Thanks,

O

1 Reply 1
Dan_Montoya
Community Manager
Community Manager

You can do this with the last modified field that is native in Airtable.  Customize it to look at the field you are monitoring.  If you really want it to say TODAY, you can use a formula field using IF(DATETIME_DIFF(now(), {last modified}, 'days') = 1, 'TODAY')