# 📆 Date/time formats

**URL:** <https://community.glideapps.com/t/date-time-formats/5719>\
**Category:** General\
**Created:** [March 23, 2020, 3:22pm UTC](https://community.glideapps.com/t/date-time-formats/5719 "2020-03-23T15:22:23Z")\
**Posts on this page:** 1\
**Showing post:** 41

<div class="post-metadata">

**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\
**Post date:** [April 9, 2020, 3:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/41 "2020-04-09T15:12:17Z")

</div>

Hi, had the same problem earlier this week, and changing the Spreadsheet Settings outlined here solved the issue for me. [https://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales](https://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales)

For some reason, both my Locale and Time Zone were both set to London, even though I live in the U.S. So, I changed them both to U.S. (where I live) and problem was solved.

Here’s another place in the documentation that talks about this: [https://docs.glideapps.com/all/reference/using-sheets/sheets-faq#im-having-problems-with-date-and-time-formatting](https://docs.glideapps.com/all/reference/using-sheets/sheets-faq#im-having-problems-with-date-and-time-formatting)

 ![locale](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5bd36d54a1e7ccbc4223ca70e93eaa53c1bff7a1.png)

Let me know if this works…

---

_[View the full topic](https://community.glideapps.com/t/date-time-formats/5719)._
