Date shows wrong?

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.

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?

Screenshot1 Screenshot2 Screenshot3

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:


This page is a good reference for date formatting:

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.