Date shows wrong?

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?

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:

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

1 Like

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