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
85 6
cancel
Showing results for 
Search instead for 
Did you mean: 

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

@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.

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.

Labels