# Problem selecting a date in calendar

**URL:** https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958
**Category:** Ask for Help
**Created:** [March 31, 2021, 6:56am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958 "2021-03-31T06:56:14Z")
**Posts on this page:** 15
**Page:** 1

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [March 31, 2021, 6:56am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/1 "2021-03-31T06:56:15Z")

</div>

Hello all,  
I have a probleme in the app display: when selecting a date it shows sometimes the day before. It happens for April , 1st ( it displays 31/03/1977) and October 25 1987 (it displays 24/10/1987) . Can someone please help me ?  
Thanks a lot ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a605bfe70121b35a5b418575c6835c104686375.jpeg)

---

<div class="post-metadata">

### Author: ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [March 31, 2021, 9:42am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/2 "2021-03-31T09:42:21Z")

</div>

Wow that’s a bit strange. Can you check if you have correctly the columns set to date and when pick a date that is that one the column that you want to edit and also that is the one you want to display it? maybe is happening something at the backend.

---

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [March 31, 2021, 10:46am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/3 "2021-03-31T10:46:57Z")

</div>

Thanks a lot for your answer , yes I checked all is ok , it is the correct column on the back end. Even weirder on the builder it shows the correct date but not on the link for the app

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e68c868592a33ca8c13e2da12a8bdf106df38721.jpeg)

---

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [March 31, 2021, 10:49am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/4 "2021-03-31T10:49:47Z")

</div>

On the builder

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b56d2b83dc7057a5e48cbd2f2ff83c56dc4992cf.jpeg)

---

<div class="post-metadata">

### Author: ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [March 31, 2021, 4:13pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/5 "2021-03-31T16:13:47Z")

</div>

wow thats super strange

---

<div class="post-metadata">

### Author: ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [March 31, 2021, 4:24pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/6 "2021-03-31T16:24:16Z")

</div>

Where is it gathering this information from and is there something adding values to dates anywhere in glide or in your spreadsheets?

---

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [March 31, 2021, 4:50pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/7 "2021-03-31T16:50:58Z")

</div>

In my sheet the column is set a “date” and in the builder sheet also.  
it is displayed as a an action text /  
the only way to modify it is on each persone profile via the little crayon and via a date picker

I don’t know if that’s clear enough?

---

<div class="post-metadata">

### Author: ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)
#### Post date: [March 31, 2021, 5:14pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/8 "2021-03-31T17:14:06Z")

</div>

it’s clear. I was thinking if you did a math column or something like that but if you said that its simply normal i don’t know what could be. Have you tried to make same with another column? maybe is bugged or something

---

<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: [March 31, 2021, 6:42pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/9 "2021-03-31T18:42:56Z")

</div>

Have you tried other phones or other brands of phones? I’m wondering if the device itself is having trouble converting and displaying a date properly. I know when doing date math, you can run the risk of date drift if you don’t properly account for leap years. It all depends on how well a device is capable of converting the underlying date to a friendly date format.

---

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [April 1, 2021, 9:49am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/10 "2021-04-01T09:49:59Z")

</div>

I’ve tried to add another column but I have the same problem again ☹

---

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [April 1, 2021, 9:51am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/11 "2021-04-01T09:51:31Z")

</div>

maybe you are right, I’ve only tried on iphones ,I will try with other brand.

---

<div class="post-metadata">

### Author: ![Pauline](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauline/32/24200_2.png) [@Pauline](https://community.glideapps.com/u/Pauline)
#### Post date: [April 1, 2021, 12:36pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/12 "2021-04-01T12:36:08Z")

</div>

yes , no problem on Samsung, must be an iphone error !  
Thanks a lot  
anyway to correct that?

---

<div class="post-metadata">

### Author: ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)
#### Post date: [April 1, 2021, 12:40pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/13 "2021-04-01T12:40:21Z")

</div>

IPhones=trouble. Not worth their value 😀😀

---

<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: [April 1, 2021, 1:23pm UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/14 "2021-04-01T13:23:55Z")

</div>

Yes, destroy all Apple devices. 😉 They’re holding the rest of us back.

I would be curious if you tried a different browser on the iphone. I wonder if the browser is interpreting the date incorrectly, or if it’s the OS. It’s hard to say if it’s a Glide, OS, or Browser issue. Maybe try a date/time picker instead and try with midnight for the time and maybe a couple of hours after midnight to see if that does anything. Just trying to think of different things to try to narrow down where the problem is.

If you get to the point where you test with different times on the same date and it starts to work, let me know.

---

<div class="post-metadata">

### Author: ![KenApp](https://avatars.discourse-cdn.com/v4/letter/k/57b2e6/32.png) [@KenApp](https://community.glideapps.com/u/KenApp)
#### Post date: [June 20, 2021, 6:07am UTC](https://community.glideapps.com/t/problem-selecting-a-date-in-calendar/24958/15 "2021-06-20T06:07:31Z")

</div>

Did anyone ever get to the bottom of this? I’m having the exact same issue on my iPhone. Difficult to know if it’s just my iPhone device but the dates/times appear fine on the app builder and android device I have. It’s a bit of a show stopper for me if it’s happening on all iPhones. That’s \> 50% of the people using the app. Thanks in advance.
