# Urgent ! Date become Weird but when only using Phone

**URL:** <https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761>\
**Category:** Report a Bug\
**Created:** [August 7, 2023, 1:21am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761 "2023-08-07T01:21:48Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 7, 2023, 1:21am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/1 "2023-08-07T01:21:48Z")

</div>

Enter date 5th August 2023 but become 8th May 2023. The problem happen only using phone. PC seems fine.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 7, 2023, 1:27am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/2 "2023-08-07T01:27:04Z")

</div>

Is the source data coming from Google Sheets?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 7, 2023, 1:27am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/3 "2023-08-07T01:27:23Z")

</div>

yes. it happen since 5th August. we are using since last year

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [August 7, 2023, 1:28am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/4 "2023-08-07T01:28:40Z")

</div>

Same issue here:

> [@Month and Day swapped in phone app](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/2):
>
> What happens if you format the date time column in Google sheets to YYYY-MM-DD

What happens if you format the date as yyyy-mm-dd in the Google Sheet?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 7, 2023, 2:02am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/5 "2023-08-07T02:02:29Z")

</div>

Same, but why its so sudden changed?  
I dont think it happen because of google sheet.

Can someone help me?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 7, 2023, 3:45am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/6 "2023-08-07T03:45:39Z")

</div>

Oh yes, i noticed that i am using Format Date Luxon Column.  
if not ,the format will become like this 2023-08-07T09:10:59.768Z

So, I am using the MM-dd-yyyy format and paste in the Date Column.  
Did you did any changes on Glide that’s affect the Format Date Column?

---

<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:** [August 7, 2023, 3:51am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/7 "2023-08-07T03:51:24Z")

</div>

The format date column is known to not work reliably with IOS/Safari. I recommend not using it.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [August 7, 2023, 4:01am UTC](https://community.glideapps.com/t/urgent-date-become-weird-but-when-only-using-phone/64761/8 "2023-08-07T04:01:20Z")

</div>

But Darren, our user mostly using android, only few users using IOS. Not sure why. Anyways thanks for letting me know