Skip to main content

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

  • January 23, 2024
  • 1 reply
  • 29 views
O
Forum|alt.badge.img

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 Attachments

1 reply

Dan_Montoya
Forum|alt.badge.img+17
  • Dan_MontoyaEmployee
  • Employee
  • January 25, 2024

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')

Terms & ConditionsAccessibility statement