# Wrong Date/Time Format in G. Sheet

**URL:** <https://community.glideapps.com/t/wrong-date-time-format-in-g-sheet/41360>\
**Category:** Ask for Help\
**Created:** [April 28, 2022, 2:54pm UTC](https://community.glideapps.com/t/wrong-date-time-format-in-g-sheet/41360 "2022-04-28T14:54:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fromthermproducao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fromthermproducao/32/42026_2.png) [@fromthermproducao](https://community.glideapps.com/u/fromthermproducao)\
**Post date:** [April 28, 2022, 2:54pm UTC](https://community.glideapps.com/t/wrong-date-time-format-in-g-sheet/41360/1 "2022-04-28T14:54:57Z")

</div>

I already changed the glide table to the short date format, and on the table it shows in the correct format, however, it posts in the G. sheet with the wrong format:  
2022-04-28T11:27:37.028Z  
 ![imagem_2022-04-28_115352176](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e68821d631cc3262a93ab8c4de09212cad0f09f5.png)

I want G. Sheet to show the following format: 28-04-2022

---

<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 28, 2022, 3:08pm UTC](https://community.glideapps.com/t/wrong-date-time-format-in-g-sheet/41360/2 "2022-04-28T15:08:58Z")

</div>

The format that you set in glide is only for display purposes on the app. The actual true timestamp value that is stored in the table is what you see in the google sheet. That is normal. If you need it to be formatted in the Google sheet, then you may have to set the formatting for the column in the google sheet, or create an additional column with an arrayformula that will parse out the date and display how you want it.

If glide did not store the date in sheet using that ISO format that you see, then it could cause several problems with dates and users that use different regional formatting for their dates.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 29, 2022, 3:09pm UTC](https://community.glideapps.com/t/wrong-date-time-format-in-g-sheet/41360/3 "2022-04-29T15:09:51Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.