# Month and Day swapped in phone app **URL:** \ **Category:** Report a Bug\ **Tags:** data-sync\ **Created:** [August 6, 2023, 8:08pm UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752 "2023-08-06T20:08:28Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Cosmoplanner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cosmoplanner/32/73444_2.png) [@Cosmoplanner](https://community.glideapps.com/u/Cosmoplanner)\ **Post date:** [August 6, 2023, 8:08pm UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/1 "2023-08-06T20:08:28Z")
_First time reporting a bug? [Refer to our Start Here post.](https://community.glideapps.com/t/start-here-reporting-platform-bugs-issues/40)_ * * * **My App/Pages support link:** - Instructions: [www.glideapps.com/docs/reference/account/support#support-link](http://www.glideapps.com/docs/reference/account/support#support-link) **Describe the bug:** - On some user phones, the app swaps the Month and Date on the dates from the Date&Time columns. On the glide web builder it shows correctly. **Expected behavior:** - For the 4 months I have had the app published there has not been any issue with the phone app swapping the months and days, but on the last few days I noticed that the Month and Day are not read properly by the phone app which is causing the app to malfunction. I had not done any updates or changed anything. While the Glide app builder reads the dates correctly, the phone app is not. **How to replicate:** - My data source is on google sheets, with the following format: ![Screenshot 2023-08-06 at 21.46.49](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f68ced4dfc7280babe57acb8f750e8be9f638cc8.png) Here is how it is read correctly by Glide Data Editor: ![Screenshot 2023-08-06 at 21.49.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28dfd947ca226f4da00ef3639c66554866459c0c.png) And here is on the phone app: ![IMG_29A341E1E0E1-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/2031f760fd32dc2f8565a902bf2339089bc726fe.jpeg) The correct date is 9th February (mm-dd \> 02/09) not 2nd September (09/02) The issue has been spotted on iphones using 16.6. Thank you so much. Ester **Link to demo recording (optional):** - Create a screen recording with [Loom](https://www.loom.com) ---
**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 6, 2023, 10:44pm UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/2 "2023-08-06T22:44:50Z")
What happens if you format the date time column in Google sheets to YYYY-MM-DD ---
**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:53am UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/3 "2023-08-07T03:53:52Z")
Are you using the [Format Date](https://www.glideapps.com/plugins/format-date) column anywhere in your App? ---
**Author:** ![l3oy8231](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l3oy8231/32/32303_2.png) [@l3oy8231](https://community.glideapps.com/u/l3oy8231)\ **Post date:** [August 7, 2023, 5:27am UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/4 "2023-08-07T05:27:17Z")
An error has been found on iOS in the calendar function. ![1691373086221](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc5eead873f4631932fc07ede043caccd6bd564c.jpeg) - In Glide Editor shows correct information. - In Pc View (Google Chrome) is displayed correctly. - In Android display is correct. Never had any problems before. This app has been used for 7 months. **Edit : Looks like yyyy/MM/dd for a while, it works in iOS and every platform.** ---
**Author:** ![Cosmoplanner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cosmoplanner/32/73444_2.png) [@Cosmoplanner](https://community.glideapps.com/u/Cosmoplanner)\ **Post date:** [August 7, 2023, 7:22am UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/6 "2023-08-07T07:22:55Z")
I am not using Format Date anywhere. ---
**Author:** ![Cosmoplanner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cosmoplanner/32/73444_2.png) [@Cosmoplanner](https://community.glideapps.com/u/Cosmoplanner)\ **Post date:** [August 7, 2023, 9:13am UTC](https://community.glideapps.com/t/month-and-day-swapped-in-phone-app/64752/7 "2023-08-07T09:13:08Z")
UPDATE: I have reformatted the dates using the ISO 8601 format as follows and it works fine: 2019-09-07T15:50+00Z YYYY-MM-DD and then time added with the corresponding time zone UTC (00), adding Z so it will convert to the user’s time zone. Thank you all for your help and suggestions!