# Date in Data Grid

**URL:** <https://community.glideapps.com/t/date-in-data-grid/57416>\
**Category:** Ask for Help\
**Created:** [February 2, 2023, 1:56pm UTC](https://community.glideapps.com/t/date-in-data-grid/57416 "2023-02-02T13:56:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sprint](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@sprint](https://community.glideapps.com/u/sprint)\
**Post date:** [February 2, 2023, 1:56pm UTC](https://community.glideapps.com/t/date-in-data-grid/57416/1 "2023-02-02T13:56:31Z")

</div>

I have a data grid with a date column. When I change the date value, Glide swaps the month with the day.  
So, for example, I want to enter this date: 01/02/2023 (dd/mm/yyyyy) and it is stored as 02/01/2023 (dd/mm/yyyyy). I also tried creating a Glide table with the new time zone support function, but nothing seems to change.  
The date is correctly inserted within a form but I need it to be edited in a data grid.  
What can I do?

---

<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:** [February 2, 2023, 2:09pm UTC](https://community.glideapps.com/t/date-in-data-grid/57416/3 "2023-02-02T14:09:56Z")

</div>

When you manually type in a date, glide doesn’t know if you meant Jan 2nd or Feb 1st. By default, is going to assume US format of MM/DD/YYYY. If you are going to manually enter a date, you would be better off explicitly spelling it out, such as ‘Feb 2 2023’ or ’ 2 Feb 2023’ or using YYYY/MM/DD format, since that is internationally recognized.

---

<div class="post-metadata">

**Author:** ![sprint](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@sprint](https://community.glideapps.com/u/sprint)\
**Post date:** [February 2, 2023, 3:28pm UTC](https://community.glideapps.com/t/date-in-data-grid/57416/4 "2023-02-02T15:28:15Z")

</div>

Ok thank you! I was hoping there was a more elegant solution. Maybe in the future Glide will add the ability to change the date through a Date Picker (in a data grid).

---

<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:** [February 2, 2023, 3:47pm UTC](https://community.glideapps.com/t/date-in-data-grid/57416/5 "2023-02-02T15:47:06Z")

</div>

Yes, a date picker would be ideal. Hopefully they will expand the functionality of the data grid in the future.