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.

2 Likes

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.

image

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: https://support.airtable.com/hc/en-us/articles/360058239594

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