# Dates in calendar misinterpreted in Glide builder **URL:** \ **Category:** Report a Bug\ **Created:** [September 29, 2019, 7:23pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701 "2019-09-29T19:23:27Z")\ **Posts on this page:** 8\ **Page:** 1
**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:** [September 29, 2019, 7:23pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/1 "2019-09-29T19:23:27Z")
The calendar list does not support dates when computer has a danish (european?) setup. The first screen shot shows how the dates are represented in Google sheet. ![09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/06d6233325545773d493cb62b89cf5cb2b688ad1.png) It is how glide has specified it (MM/DD/YYYY) [https://docs.glideapps.com/all/reference/layouts/calendar#formatting-dates-to-work-with-the-calendar](https://docs.glideapps.com/all/reference/layouts/calendar#formatting-dates-to-work-with-the-calendar) But when you look at it in the glide builder (in app on iOS it is ok) it shows up as june and december entries. ![43](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/b84a077452bf8190d7e194507f167f6a36e3a2ed.png) Try also to look at how Google sheets interprets the date - the are interpretted all as june ![46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/c7733fccec246f727f3798ef0fe5e15f964c6299.png) ![47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/4f81a0e8cd4603274a68d3d9dfc32b8c98f1e6d6.png) So to me - this is a bug. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 29, 2019, 11:31pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/2 "2019-09-29T23:31:33Z")
We will fix this eventually. In the mean time, please use [the date format we recommend in the documentation](https://docs.glideapps.com/all/reference/layouts/calendar#formatting-dates-to-work-with-the-calendar). ---
**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:** [September 30, 2019, 5:22am UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/3 "2019-09-30T05:22:53Z")
Hi @Mark I’m inputting the format that you have specified. Google sheets transforms this to a date-time. And then - the problem is as described above. June 13th and December 6th I even tried to concatenate two strings to cheat google not to convert the data to a datetime. This is the same result. ![25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/c0077406244ae6871bc77b413bffe69b75657531.png) I dont’t see any possibilities to input the data in another way where data will show up correctly in the Glide builder. Please correct me if I’m wrong ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [September 30, 2019, 5:57am UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/4 "2019-09-30T05:57:29Z")
I found out that it helps when you set both the whole document and the column to the right mm/dd/yy format. Even if you filled it in right, set the column format right too. That helped with me. Ans set the doc to US Locale. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 30, 2019, 12:39pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/5 "2019-09-30T12:39:51Z")
I’m trying to reproduce this issue but have a hard time. Which browser are you using? Does this happen with a different browser for you, too? ---
**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:** [September 30, 2019, 2:09pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/6 "2019-09-30T14:09:45Z")
Hi @Mark , I’m using Chrome on Macbook Air. The document is set to US Locale. I have also tested on a Win10 machine. Here it look as expected - so I conclude that the problem has to do with Mac. And it works correctly in the app - so in that way - a smaller problem than expected. Kristian ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 30, 2019, 2:33pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/7 "2019-09-30T14:33:52Z")
We have just deployed a fix. Please let us know if you see the problem again. ---
**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:** [September 30, 2019, 3:14pm UTC](https://community.glideapps.com/t/dates-in-calendar-misinterpreted-in-glide-builder/701/8 "2019-09-30T15:14:30Z")
@Mark Things are working now on Macbook Air with chrome browser Thx