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
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')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.