# šŸ“† Date/time formats **URL:** https://community.glideapps.com/t/date-time-formats/5719 **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:** 2
### 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, 7:09pm UTC](https://community.glideapps.com/t/date-time-formats/5719/21 "2020-03-26T19:09:21Z")
@Daniel_Lozano couldnā€™t get it to work, unfortunatelyā€¦ but I can wait for a fix. Thanks for helping out. @Mark if it helps, I recorded a test post on my phone and you can see how the timestamp initially displays but quickly disappears after a few seconds. Thanks again! ![RPReplay-Final1585249047](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/24412b03d58b8d8d43ac94589c585af7527f2164.gif) ---
### 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, 7:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/22 "2020-03-26T19:12:34Z")
This should be fixed later today. ---
### Author: ![Ken](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ken/32/4483_2.png) [@Ken](https://community.glideapps.com/u/Ken) #### Post date: [March 26, 2020, 7:16pm UTC](https://community.glideapps.com/t/date-time-formats/5719/23 "2020-03-26T19:16:46Z")
Lol! I agree with you on that @Rosewebstudio ---
### Author: ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez) #### Post date: [April 1, 2020, 8:10am UTC](https://community.glideapps.com/t/date-time-formats/5719/24 "2020-04-01T08:10:33Z")
Hi @Mark Please when will be unnecessary to have dates in US format?? Hope soon is close. Thanks!! ---
### 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: [April 1, 2020, 4:00pm UTC](https://community.glideapps.com/t/date-time-formats/5719/25 "2020-04-01T16:00:08Z")
Probably Tuesday. ---
### Author: ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb) #### Post date: [April 1, 2020, 6:09pm UTC](https://community.glideapps.com/t/date-time-formats/5719/26 "2020-04-01T18:09:16Z")
Thank you so much! I had posted about this yesterday, requesting this feature. Itā€™s no longer displaying 24-hr format for user upon clicking on calendar event. Appreciate it! ---
### Author: ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb) #### Post date: [April 1, 2020, 6:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/27 "2020-04-01T18:12:19Z")
Have you guys noticed too how Sheets displays the calendar? So in Glide, it displays the correct date that I entered in Sheets: April 2, 2020. But in Sheets, it reverses the month and day to show it like this. I know this isnā€™t a Glide issue, but kind of confusingā€¦ ![sheets-bug](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/163cb274c7fa4a890f29301e04a0cf57901effe2.png) ---
### Author: ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez) #### Post date: [April 3, 2020, 11:41am UTC](https://community.glideapps.com/t/date-time-formats/5719/28 "2020-04-03T11:41:05Z")
Soā€¦in data editor with theā€¦ if then columnā€¦ when ā€¦if date is within todayā€¦ it takes dates 4 March instead today 3 Abril. It is supposed this will be consequently working ok probably on Tuesday. Right @Mark ?? Thanks ---
### 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: [April 3, 2020, 12:02pm UTC](https://community.glideapps.com/t/date-time-formats/5719/29 "2020-04-03T12:02:42Z")
The same thing happened to @kyleheney with my Meet With Me app: > [@Send google calendar invites](https://community.glideapps.com/t/send-google-calendar-invites/5658/13): > > Hmā€¦is your name Kyle? If soā€¦I had the Zap error out because it didnā€™t have the End Time configured correctly. Iā€™ll take a look. ---
### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney) #### Post date: [April 3, 2020, 5:21pm UTC](https://community.glideapps.com/t/date-time-formats/5719/30 "2020-04-03T17:21:39Z")
Iā€™m having a Date/Time issue. I have a Choice Component that has the user selecting a date field ---- the sheet where the choices are stored is recognizing this column as a Date field in the Editor. When the user submits a response and the Date field is recorded using a ā€œColumnā€ component to capture the selected date, the response is recorded in a text format and not a date format. In the Editor, my Responses sheet then displays this field as a text column and not a date column. Because of this, I cannot apply a date filter to the responses, as itā€™s recognized as a text field and not a date field. If I change the formatting in my spreadsheet for the Date column on my Responses sheet, it updates the current values to a Date format, but anything submitted afterwards gets inserted into my sheet as a piece of text (i.e. 'March 31, 2020). ---
### 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: [April 3, 2020, 5:44pm UTC](https://community.glideapps.com/t/date-time-formats/5719/31 "2020-04-03T17:44:04Z")
Right. I noticed this too. ---
### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK) #### Post date: [April 3, 2020, 6:20pm UTC](https://community.glideapps.com/t/date-time-formats/5719/32 "2020-04-03T18:20:06Z")
Yepā€¦ Also for graph, same problem. ---
### 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: [April 3, 2020, 6:31pm UTC](https://community.glideapps.com/t/date-time-formats/5719/33 "2020-04-03T18:31:51Z")
Thanks for reporting this. Weā€™ll look into it. @Christophe_HK What do you mean ā€œgraphā€? ---
### 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 3, 2020, 6:57pm UTC](https://community.glideapps.com/t/date-time-formats/5719/34 "2020-04-03T18:57:03Z")
Glide lets you create new columns now and define the type right away in the data tab. Looks like you can plug in a date and itā€™s recognized as a date. Try that once. Unless itā€™s how you have the date formatted in the choice component. I just tried typing a date in a text box and that seemed fine, but it looked like this ā€˜3/14/2020 20:55:00ā€™ ---
### 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: [April 3, 2020, 9:16pm UTC](https://community.glideapps.com/t/date-time-formats/5719/35 "2020-04-03T21:16:54Z")
I saw that! I had to do a double take and wonder if I had missed that all along. ---
### 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 3, 2020, 9:55pm UTC](https://community.glideapps.com/t/date-time-formats/5719/36 "2020-04-03T21:55:30Z")
I had seen it in staging the other day. I was surprised that it was in production. ---
### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK) #### Post date: [April 3, 2020, 10:27pm UTC](https://community.glideapps.com/t/date-time-formats/5719/37 "2020-04-03T22:27:14Z")
Hi @Mark, In my gsheet, I have set all dates using the UI format as advised, even if my app is French (and so dd/mm/yyyy instead of mm/dd/yyyy). In the data editor, I see my date column and I apply the ā€œshortā€ dat (only) format. It appears correctly in the dd/mm/yyyy format. Thatā€™s ok, and alo OK when the date is displayed by text components within my app. But, using a bar chart, I noticed a bug : dates format is not managed correctly. See hereafter what happens : ![bar_chart_issue](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c8cade49cffcdfba2bb4a402b1faac9589c65264.png) Displayed as ā€œtextā€, the date is correct, I mean in the expected format (dd/mm/yyyy). But using graph, US formatā€¦ Thereā€™s probably a way to work around this problem, by casting these dates as text in the correct format. But my app is going to be full of data soon, so if I can avoid to add non necessary data in the sheet, it would be better for meā€¦ Anyway, I dont put lot of pressure for this problem, itā€™s not so critical : I can explain to end users. Christophe ---
### 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: [April 4, 2020, 12:33am UTC](https://community.glideapps.com/t/date-time-formats/5719/38 "2020-04-04T00:33:40Z")
I see the bug. Weā€™ll fix it. Thank you for reporting! ---
### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney) #### Post date: [April 9, 2020, 1:56pm UTC](https://community.glideapps.com/t/date-time-formats/5719/39 "2020-04-09T13:56:16Z")
Hi @Mark, There have been issues with Date/Time formats for the last few days. Itā€™s causing some serious issues with an app Iā€™m relying on for scheduling purposes. Formats are getting changed, seemingly for no reason. My Sheetā€™s array formulas arenā€™t even able to get the formatting corrected in the sheet, which is leading to relations not matching, etc etc. Can someone look at this asap? Iā€™d be happy to provide access to my app to an admin who can look at the issues through a private message (as the app has private information). Thank you ---
### Author: ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo) #### Post date: [April 9, 2020, 2:58pm UTC](https://community.glideapps.com/t/date-time-formats/5719/40 "2020-04-09T14:58:11Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4617b9e339632a2cc61017ce4a454a1e4825e093.png) I have the same problem, my date format is DD/MM/YYYY in the first picture using calendar the date is displayed with MM/DD/YYYY the second picture it is correctly displayed. [Previous page](https://community.glideapps.com/t/date-time-formats/5719.md?page=1) [Next page](https://community.glideapps.com/t/date-time-formats/5719.md?page=3)