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.
Device settings is Danish/nordic/european. All users are from Denmark.
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?
@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
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?
Tak for input 
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.
I used the safari browser. The brower have no such settings. It inherits from device regional settings.
On google chrome on Iphone it works flawlessly
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?
Shows same way in data editor.
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.
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.
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 
Let’s hope it keeps working.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
