Help

Dates shown on Interface are in MM/dd/yyyy format even though original data in Base is in yyyy-MM-dd

Topic Labels: Interface Designer
1394 6
cancel
Showing results for 
Search instead for 
Did you mean: 
MK2000
4 - Data Explorer
4 - Data Explorer

When I build an Interface with my data, the date format shows up differently from how I’ve set it up in the data in the original Base and my system preferences on macOS.

Date in Base
image

Date field setting in Base
image

Date and time setting on macOS
image

Date on Interface
image

6 Replies 6
Andrey_Kovalev
8 - Airtable Astronomer
8 - Airtable Astronomer

@MK2000 It seems like the only current option for charts.

@MK2000 I’m not looking at it right now, but it’s possible that you can create a formula field to display on the X-Axis with the date formatting that you want.

MK2000
4 - Data Explorer
4 - Data Explorer

Thank you for your response, @ScottWorld. I created an additional column called “Formatted Date” which pulled data from the “Date” column and set the format to ISO. The result is the same on Interface:

image

No, I meant create a formula field with a formula like this:

DATETIME_FORMAT({Date_Field},'YYYY-MM-DD')

That seems to have fixed the formatting issue although based on how it’s displaying the date from every single data point, I think it’s treating it simply as a string as opposed to a date.

image

Unfortunately, that’s the best you’ll be able to get. I would send an email to support@airtable.com to ask them to give us date formatting options in the interface designer.

Since Airtable has failed us in these regards, your best bet would be to build your charts & graphs in some other tool, such as Google Sheets or Microsoft Excel or DataBox or any other chart-creating tool that you can find on the web.

Then, use Make to send your data from Airtable to one of those other tools. There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. There are also many Make experts hanging out there who can answer other Make questions.