# Date filled does not match the date showing up in data

**URL:** <https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166>\
**Category:** Report a Bug\
**Created:** [November 29, 2022, 11:46am UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166 "2022-11-29T11:46:17Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keren404](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/keren404/32/47015_2.png) [@Keren404](https://community.glideapps.com/u/Keren404)\
**Post date:** [November 29, 2022, 11:46am UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/1 "2022-11-29T11:46:17Z")

</div>

**My App/Pages support link:**  
[https://go.glideapps.com/support/d8be0413-ef7b-4afa-be04-1861a35f7013](https://go.glideapps.com/support/d8be0413-ef7b-4afa-be04-1861a35f7013)

**Describe the bug:**  
Users select a date from the date picker, and the date that shows up in the consultant-time table is the date of the day before

**Expected behavior:**  
the correct date should appear, not the day before

**How to replicate:**

- go to the 4th tab in the left side nav bar
- click the button at the top which opens a form
- select a date in the date picker and click submit
- see the date of the day before

**Link to demo recording:**

 ![Screenshot 2022-11-29 at 13.36.50](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c9df3d16d7e636e5f0fba9574c67b62352f20d5.png)

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 29, 2022, 1:31pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/2 "2022-11-29T13:31:10Z")

</div>

HI Keren,  
Is this a GS app?  
I had this problem also, Its was because of time zone offset.  
Are you working on a Chrome browser? Is it in English or Hebrew? Switching to Hebrew may fix it.  
Can you send me a link to the app? (not support)

---

<div class="post-metadata">

**Author:** ![Keren404](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/keren404/32/47015_2.png) [@Keren404](https://community.glideapps.com/u/Keren404)\
**Post date:** [November 29, 2022, 1:47pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/3 "2022-11-29T13:47:31Z")

</div>

Hey Lin!

Thanks but I’m afraid it’s a private app (that’s why I blanked the rest of the fields)

it’s partially English and partially Hebrew, and yes it’s based only on GS.  
Not sure where I need to switch the timezone - in the browser, you mean?

Thank you for your help!! 🙏 🙏 🙏

---

<div class="post-metadata">

**Author:** ![Keren404](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/keren404/32/47015_2.png) [@Keren404](https://community.glideapps.com/u/Keren404)\
**Post date:** [November 29, 2022, 1:51pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/4 "2022-11-29T13:51:20Z")

</div>

I just tried changing the timezone and unfortunately it did not have any effect ☹

Looks like a bug, TBH…

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 29, 2022, 1:56pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/5 "2022-11-29T13:56:49Z")

</div>

Try to change the browser to Hebrew.  
No guarantee it would work for other users

---

<div class="post-metadata">

**Author:** ![Keren404](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/keren404/32/47015_2.png) [@Keren404](https://community.glideapps.com/u/Keren404)\
**Post date:** [November 29, 2022, 3:11pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/6 "2022-11-29T15:11:05Z")

</div>

SO I found a way to change the location in my browser and it worked!

Unfortunately, my users are highly un-technical and some use it from mobile devices so I can’t explain it to them… created a workaround of a calculated field that adds a day 💁‍♀️

Thanks a lot Lin!

---

<div class="post-metadata">

**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 29, 2022, 11:41pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/7 "2022-11-29T23:41:13Z")

</div>

Open your Google Spreadsheet, then go to File → Settings, then check the Time Zone setting.

 ![Screen Shot 2022-11-30 at 7.40.02 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b9e3997e73f06215c039d2706bc648d486d93b91.png)

---

<div class="post-metadata">

**Author:** ![Keren404](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/keren404/32/47015_2.png) [@Keren404](https://community.glideapps.com/u/Keren404)\
**Post date:** [November 30, 2022, 10:01am UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/8 "2022-11-30T10:01:44Z")

</div>

Thanks Darren but this doesn’t have a spreadsheet.

---

<div class="post-metadata">

**Author:** ![Keren404](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/keren404/32/47015_2.png) [@Keren404](https://community.glideapps.com/u/Keren404)\
**Post date:** [December 14, 2022, 4:08pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/9 "2022-12-14T16:08:34Z")

</div>

Just in case anyone gets here in trying to solve the same issue:  
there seems to be a solution in the edit field:  
 ![Screenshot 2022-12-14 at 18.06.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/9/f90451f0bcbcd60699476d5d88d98c5154d4f2d2.png)

---

<div class="post-metadata">

**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:** [December 14, 2022, 4:23pm UTC](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166/10 "2022-12-14T16:23:14Z")

</div>

That checkbox should not be the fix for this issue. Respect timezones means the time you see could be different from the time I see due to different timezones. When it’s unchecked, all users see the same time regardless of the timezones they are in. If this issue is still happening, then there is still a bug or some issue with the time settings on your device, such as mismatched timezones and time.
