# How do i show dates as in my airtable base **URL:** \ **Category:** Ask for Help\ **Tags:** date-math\ **Created:** [November 13, 2023, 10:15pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770 "2023-11-13T22:15:32Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 13, 2023, 10:15pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/1 "2023-11-13T22:15:32Z")
The date is formatted and presented as i’d like in airtable as european DDMMYY but glide app shows it as MMDDYY How can i change this? I even create a formula field in airtable that would output the date in a text format but glide still treats it and converts how it’s showing. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 13, 2023, 11:03pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/2 "2023-11-13T23:03:43Z")
I would start by checking the region settings on your device. > [@Date picker starts with Sunday for some user](https://community.glideapps.com/t/date-picker-starts-with-sunday-for-some-user/67708/4): > > Like @Darren_Murphy said, that all depends on each individual user’s device. Glide adapts to different regions to show numbers, dates, date pickers, and various other things appropriately for the user’s region. My guess is that you have some users that have there device OS or Browser region set to US English for example instead of the correct region for their location, so everything is going to display in a way that’s normal for users in the USA. Which country are your users located? How do … ![Screenshot_20231113-170234](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/114cd8aff69c6b644aaf7862a1563bf8a4f3e023.png) > **[Basic Columns](https://www.glideapps.com/docs/essentials/basic-columns#date-formatting-options)** > > Add and manage basic data like text, numbers, and images. ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 14, 2023, 11:35am UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/3 "2023-11-14T11:35:36Z")
Device settings is Danish/nordic/european. All users are from Denmark. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 14, 2023, 1:47pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/4 "2023-11-14T13:47:52Z")
Have you or other users tried using your app on different devices? I would be surprised if everybody experienced the same issue. What is the device type, OS version, and browser that you are using and experiencing this issue. Can you show a screenshot of your region/locale settings for the OS as well as the browser? @Krivo would you have any insight? Have you had any issues with dates formatting in MMDDYYYY instead of DDMMYYYY? ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [November 14, 2023, 2:45pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/5 "2023-11-14T14:45:17Z")
@Jeff_Hager @Scd Hej fra København 😃 I dont have problems with dates (sometimes in the old days when I used google sheets). I don’t use airtable so no experience there. Sorry ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 16, 2023, 8:51am UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/6 "2023-11-16T08:51:47Z")
![IMG_5587](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1fd8a761e38e024d6b3a155f0bde471f85db126b.jpeg) ![IMG_5586.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/627497c94188a914602138a39217f938792cfac2.jpeg) ![IMG_5585.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b7c3dfece78be8bf0b9c209fcd61d0a444790d6.jpeg) I’ve done all i can. Tried multiple different devices. Do Glide have some rules/requirements for how the settings on the date column in Airtable should be? ![Skærmbillede 2023-11-16 kl. 09.51.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/10e8fcfdb7fce5dd862dcb6e8aed383f666a3936.png) ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 16, 2023, 8:56am UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/7 "2023-11-16T08:56:53Z")
Tak for input 🙂 - Odense ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 16, 2023, 12:27pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/8 "2023-11-16T12:27:20Z")
Does the browser itself have any settings for the language or region? Are you using the Safari browser? Sorry, I don’t use an iPhone, so I’m not familiar with all of the settings that are available to you. ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 16, 2023, 12:52pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/9 "2023-11-16T12:52:58Z")
I used the safari browser. The brower have no such settings. It inherits from device regional settings. ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 16, 2023, 12:54pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/10 "2023-11-16T12:54:22Z")
On google chrome on Iphone it works flawlessly 🙂 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 16, 2023, 2:32pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/11 "2023-11-16T14:32:18Z")
Sorry, I don’t have any other suggestions. Especially since I have no way to test it for myself. I see nothing wrong with the settings you have shown. While I do understand that it would be nice to have more control over these settings, Glide currently attempts to figure it out for you based on each user’s device settings. In most cases I believe it works well, so I’m not sure what would cause it to not work. I don’t believe that it has anything to do with the format of the date in your Airtable. I can see cases where it might confuse day and month, but with your 11/13/2023 date, there is obviously no 13th month, so no way to confuse the two. It’s obviously showing in MM/DD/YYYY. Just to be clear, the way the date is shown in the grid is the same way it is shown in the Glide data editor? Is your date column type configured as a date column? ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 17, 2023, 10:52am UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/12 "2023-11-17T10:52:45Z")
Shows same way in data editor. ![Skærmbillede 2023-11-17 kl. 11.49.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd435e4414ed9c518783e759e10756198d4b8297.jpeg) It suddenly works. I can see it correctly in the app now. What might be the reason and i’m no expert, is depending on the wifi you’re on, if that hides anything from the glide services. IDK. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 17, 2023, 11:03am UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/13 "2023-11-17T11:03:39Z")
Is that the first time you’ve edited that column? I’ve seen it happen in the past with external data sources where Glide doesn’t properly identify the data type. You’ll see the column type as Date & Time, and the values will “look” like dates, but they won’t be properly handled as dates. The simple act of editing the column type and saving it again is usually enough to sort this out. You would have been able to tell if that’s what happened in this case, as you would have seen the appearance of the date values change as soon as you opened the column editor. I don’t use Airtable, but I’ve seen this happen many times with Google Sheets. ---
**Author:** ![Scd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scd/32/49495_2.png) [@Scd](https://community.glideapps.com/u/Scd)\ **Post date:** [November 17, 2023, 12:17pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/14 "2023-11-17T12:17:58Z")
No, when creating the app initially i edited the column to be date only and short format. So it’s been like this for a while. Again, not sure the reason it suddenly shows correctly in the app. It still shows wrong in the data editor 🤣 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 17, 2023, 1:19pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/15 "2023-11-17T13:19:27Z")
🤞 Let’s hope it keeps working. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 24, 2023, 1:19pm UTC](https://community.glideapps.com/t/how-do-i-show-dates-as-in-my-airtable-base/67770/16 "2023-11-24T13:19:28Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.