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
Date field setting in Base
Date and time setting on macOS
Date on Interface
+35@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:
+35Thank 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:
No, I meant create a formula field with a formula like this:
DATETIME_FORMAT({Date_Field},'YYYY-MM-DD')
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.
+35That 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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
