# Glide app and builder not showing correct date

**URL:** <https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241>\
**Category:** Ask for Help\
**Created:** [July 10, 2020, 1:49am UTC](https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241 "2020-07-10T01:49:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![linlinlemon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/linlinlemon/32/5879_2.png) [@linlinlemon](https://community.glideapps.com/u/linlinlemon)\
**Post date:** [July 10, 2020, 1:49am UTC](https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241/1 "2020-07-10T01:49:20Z")

</div>

Hi all,

I’m trying to set up a calendar and have made my spreadsheet settings as my locale (Sydney, Australia). However the glide builder and app both interpret the date in US format (e.g. 12 July is reflected as 7 December).

I also tried to add an entry as a user in the app, and initially the date reflects as the correct format, then it converts to the US form. E.g. I input 12 July as 12/07/2020. It appears correctly as 12 July 2020 for a few seconds and then it changes to 7 December 2020.

Grateful if someone could shed some light!

Thanks,  
Lin

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 10, 2020, 1:52am UTC](https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241/2 "2020-07-10T01:52:24Z")

</div>

Hi Lin, do you store those dates in your Spreadsheet?

---

<div class="post-metadata">

**Author:** ![linlinlemon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/linlinlemon/32/5879_2.png) [@linlinlemon](https://community.glideapps.com/u/linlinlemon)\
**Post date:** [July 10, 2020, 2:06am UTC](https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241/3 "2020-07-10T02:06:50Z")

</div>

Hi ThinhDinh,

Yes that’s right. Strangely enough though, I just went to the data page in the builder and clicked into the date cells individually and then the dates columns converted into the Australian format.

The app and builder are now reflecting the Australia date formats. Very strange but it looks fine now… Not sure if what’s happened though.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 10, 2020, 2:08am UTC](https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241/4 "2020-07-10T02:08:06Z")

</div>

That’s definitely strange. I was about to advise you to go into the builder, click the edit option for the column and try to change things around to see if it works.

---

<div class="post-metadata">

**Author:** ![linlinlemon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/linlinlemon/32/5879_2.png) [@linlinlemon](https://community.glideapps.com/u/linlinlemon)\
**Post date:** [July 11, 2020, 2:52am UTC](https://community.glideapps.com/t/glide-app-and-builder-not-showing-correct-date/12241/5 "2020-07-11T02:52:35Z")

</div>

Ah ok, thank you for that! Yes, very strange - but at least it is working properly now 🙂