How to change the date/time format

Is there a way to make a date/time field look pretty? I’m looking to be able to format the date showing as MM/DD/YYYY HH:MM instead of the UTC format that it defaults to.

This isn’t a way to do it from within the Softr platform yet. You’ll need to create a new field in your Airtable and use the DATETIME_FORMAT function.

Documentation is here:
Supported format specifiers for DATETIME_FORMAT – Airtable Support

The use the new field in your Softr app.

Let me know if you need further help.


That was the one, thanks.

I’m still having trouble.

Here’s my formula: DATETIME_FORMAT({Time Complete},‘M/D/YYYY, hh:mm’)

Here’s the results, but the times don’t match. I don’t get it.


I would suggest using HH instead of hh also please check if you have a timezone in the first one if yet then you might need to add it to the formatting too

I found that when the actual date field has “Use the same time zone (GMT) for all collaborators” turned off (which means local timezone), and using SET_TIMEZONE() to my local time zone, the dates and times match. More info here:

Example: DATETIME_FORMAT(SET_TIMEZONE({Updated On},‘America/Phoenix’),‘LLLL’)
produces this: Thursday, October 21, 2021 7:59 AM in my time zone.

1 Like

I played with that a bit this morning and did that very thing. I think the magic is in the SET_TIMEZONE.

Thanks for the follow-up answer.

1 Like