Hello,
I want to show in a column very simply:
Last modified: 25/11/2020 14:30
‘Last modified’ is static text.
The date is ‘last modified time’ that is automatically updated when we edit the Airtable record.
Problem:
I created a formula column but it makes something very weird of the dates “2020-11-18T11:50:33.000Z”. Any ideas how to make the date appear normal?
Hi Katrien,
Welcome to the forum! In order to format your date a certain way when you use it in a formula like this, you can use the Date_Format function. In your case, it would look like this:
DATETIME_FORMAT({Last Modified},'DD/MM/YYYY HH:mm')
This page is a good reference for date formatting: https://support.airtable.com/hc/en-us/articles/216141218-Supported-format-specifiers-for-DATETIME-FORMAT
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.