# šŸ“† Date/time formats **URL:** \ **Category:** General\ **Created:** [March 23, 2020, 3:22pm UTC](https://community.glideapps.com/t/date-time-formats/5719 "2020-03-23T15:22:23Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 23, 2020, 3:22pm UTC](https://community.glideapps.com/t/date-time-formats/5719/1 "2020-03-23T15:22:23Z")
Glide can now format your šŸ“… date and ā° time columns, in the app userā€™s language, very similar to how [number formats](https://community.glideapps.com/t/number-formats/5226) work: ![2020-03-17 19.14.58](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3d152cab753467fea496b519f12929e99ddacce2.gif) **For the time being, you still need to put your date/times in your spreadsheet in US format (month/day/year)**, but we will soon make that unnecessary, too. Please let us know what you think, and if you run into any issues. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 23, 2020, 4:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/2 "2020-03-23T16:12:52Z")
Another super addition, these glide updates are getting addictive ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [March 23, 2020, 4:41pm UTC](https://community.glideapps.com/t/date-time-formats/5719/3 "2020-03-23T16:41:14Z")
I just found it in an app I was finishing this morning. Timing was perfect, and it worked like I expected. Thanks for all you do for us. ---
**Author:** ![Rosinda\_Anthony](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosinda_anthony/32/1099_2.png) [@Rosinda\_Anthony](https://community.glideapps.com/u/Rosinda_Anthony)\ **Post date:** [March 23, 2020, 5:46pm UTC](https://community.glideapps.com/t/date-time-formats/5719/4 "2020-03-23T17:46:57Z")
Thanks, Mark! ---
**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:** [March 23, 2020, 6:03pm UTC](https://community.glideapps.com/t/date-time-formats/5719/5 "2020-03-23T18:03:46Z")
Nice! One less formula I need to add To my spreadsheet. Keep them coming! Any thoughts on including a current time date column in the data editor?! šŸ˜‰ ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [March 23, 2020, 10:05pm UTC](https://community.glideapps.com/t/date-time-formats/5719/6 "2020-03-23T22:05:17Z")
Excellent. Can we make Glide columns that duplicate the data in a Date/Time column and format that column the same (like using Template or If - Then - Else)? If we want two different columns with different visual formats in the app. Or is there a way to change date formatting in the components themselves yet? ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 23, 2020, 11:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/7 "2020-03-23T23:12:43Z")
@John_Cabrera Not yet, unfortunately. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [March 23, 2020, 11:14pm UTC](https://community.glideapps.com/t/date-time-formats/5719/8 "2020-03-23T23:14:05Z")
No problem. This is still quite epic. And a stepping stone for those kinds of additions, Iā€™m sure. ---
**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 24, 2020, 1:01pm UTC](https://community.glideapps.com/t/date-time-formats/5719/9 "2020-03-24T13:01:49Z")
> [@Robert\_Petitto](#): > > current time date column Can you explain this one a little more? I looked at your feature request, but Iā€™m not sure I understand how it would work. ---
**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:** [March 24, 2020, 1:03pm UTC](https://community.glideapps.com/t/date-time-formats/5719/10 "2020-03-24T13:03:33Z")
Like a ā€œsingle valueā€ column but it outputs (and updates) current date time. Doesnā€™t get pulled from the sheetā€¦Glide provides. ---
**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 24, 2020, 1:05pm UTC](https://community.glideapps.com/t/date-time-formats/5719/11 "2020-03-24T13:05:25Z")
How would you use it? ---
**Author:** ![emilio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emilio/32/2944_2.png) [@emilio](https://community.glideapps.com/u/emilio)\ **Post date:** [March 26, 2020, 5:36pm UTC](https://community.glideapps.com/t/date-time-formats/5719/12 "2020-03-26T17:36:34Z")
Hi, I recently updated my date and time column and everything worked great, except the data isnā€™t showing up on the downloaded app on my phone. Itā€™s viewable from the app on my desktop, but not the one on my phone. I already deleted it and downloaded again, but nothing. Any ideas why data isnā€™t showing? Here are some screenshotsā€¦ ![IMG_3921](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/36b57bcb3eeac9f18fbcb772087414ab2bf51973.jpeg) ![Screen Shot 2020-03-26 at 10.27.20 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f6f22951dcf6d0492e066f4ed4861bc3e8045c90.png) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 26, 2020, 5:37pm UTC](https://community.glideapps.com/t/date-time-formats/5719/13 "2020-03-26T17:37:44Z")
@emilio Could you share your app, please, and tell me how to get to that screen? ---
**Author:** ![emilio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emilio/32/2944_2.png) [@emilio](https://community.glideapps.com/u/emilio)\ **Post date:** [March 26, 2020, 5:43pm UTC](https://community.glideapps.com/t/date-time-formats/5719/14 "2020-03-26T17:43:38Z")
Thanks @Mark. Hereā€™s my app [demo-english.glideapp.io](http://demo-english.glideapp.io). To get to that screen go to the **Messages** tab \> **ā€œNew Mexican Restaurantā€** post. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 26, 2020, 6:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/15 "2020-03-26T18:12:13Z")
I see. Iā€™m guessing this is because Safari canā€™t parse the date you have in your spreadsheet, but Chrome can (weā€™ll fix this problem soon). Whatā€™s in your sheet in that column? ---
**Author:** ![emilio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emilio/32/2944_2.png) [@emilio](https://community.glideapps.com/u/emilio)\ **Post date:** [March 26, 2020, 6:21pm UTC](https://community.glideapps.com/t/date-time-formats/5719/16 "2020-03-26T18:21:08Z")
Alright, no rush. Just wanted to make sure there wasnā€™t anything wrong on my end. Itā€™s just dummy data, nothing critical. ---
**Author:** ![Daniel\_Lozano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lozano/32/4780_2.png) [@Daniel\_Lozano](https://community.glideapps.com/u/Daniel_Lozano)\ **Post date:** [March 26, 2020, 6:28pm UTC](https://community.glideapps.com/t/date-time-formats/5719/17 "2020-03-26T18:28:26Z")
Emilio, I had that problem as well. Check your date format in your Google Sheet, it should be MM/DD/YYYYā€¦ I had it as DD/MM/YYYY and safari, for some reason, couldnā€™t read it. ---
**Author:** ![emilio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emilio/32/2944_2.png) [@emilio](https://community.glideapps.com/u/emilio)\ **Post date:** [March 26, 2020, 6:33pm UTC](https://community.glideapps.com/t/date-time-formats/5719/18 "2020-03-26T18:33:58Z")
Thank you @Daniel_Lozano. It makes sense, but the date was generated automatically. ![Screen Shot 2020-03-26 at 11.29.35 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5d6b22a51bbe5515738954880ef222592baec6f4.png) Itā€™s an old post, Iā€™m going to upload a new one and see if that changes anything. ---
**Author:** ![Daniel\_Lozano](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_lozano/32/4780_2.png) [@Daniel\_Lozano](https://community.glideapps.com/u/Daniel_Lozano)\ **Post date:** [March 26, 2020, 6:35pm UTC](https://community.glideapps.com/t/date-time-formats/5719/19 "2020-03-26T18:35:32Z")
It happened to me as wellā€¦ for some reason, after selecting the date column and reformatting it to MM/DD/YYYY, it got fixed. But this is definitely something that shouldnā€™t happen! ---
**Author:** ![emilio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emilio/32/2944_2.png) [@emilio](https://community.glideapps.com/u/emilio)\ **Post date:** [March 26, 2020, 6:36pm UTC](https://community.glideapps.com/t/date-time-formats/5719/20 "2020-03-26T18:36:04Z")
Ok, let me try. šŸ‘ [Next page](https://community.glideapps.com/t/date-time-formats/5719.md?page=2)