# In-app filter with dates shows dates in ugly format **URL:** \ **Category:** Report a Bug\ **Created:** [May 9, 2020, 9:29pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818 "2020-05-09T21:29:13Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 9, 2020, 9:29pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/1 "2020-05-09T21:29:13Z")
Hello everyone, I have an app where I use in-app filter with dates, but it shows dates in a very ugly way. ![Captura de pantalla 2020-05-10 a las 0.22.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b3d99e6d660b8fd2eba767707c6e1c200cee064d.png) In data builder I have configures how to visualize dates, but it seems to me that this does not affect to in-app filter… ![Captura de pantalla 2020-05-10 a las 0.27.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7f9758d36dbd7887ef07b87b5eed06c71c62aab4.png) Is there a way to change that? Thank you! ---
**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:** [May 9, 2020, 9:31pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/2 "2020-05-09T21:31:08Z")
Hm. Might need to convert the dates to pretty dates using `=text()` formula in sheets. Not ideal, but it will work. ---
**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:** [May 9, 2020, 9:45pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/3 "2020-05-09T21:45:54Z")
I could have sworn somebody else reported this recently, but I can’t find a post. This is the closest thing I could find, so maybe this is what I was thinking of. > [@Pretty Timestamp not displaying in Tile Caption](https://community.glideapps.com/t/pretty-timestamp-not-displaying-in-tile-caption/6609): > > My app’s URL: [challenges.glideapp.io](http://challenges.glideapp.io) [Screen Shot 2020-04-08 at 7.03.59 AM] ---
**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:** [May 9, 2020, 9:56pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/4 "2020-05-09T21:56:32Z")
That’s a bug. We’ll fix it. Thank you so much for reporting! ---
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 10, 2020, 11:17am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/5 "2020-05-10T11:17:33Z")
Thank you! I have discovered that this is the format in which glide saves the dates because if I insert a TextEntry component, it shows the same. In the image, both component refer to the same column. ![Captura de pantalla 2020-05-10 a las 14.14.41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d35d30a4cf667d0fc5ee235b081500cd3ebe3321.png) ---
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 10, 2020, 11:19am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/6 "2020-05-10T11:19:08Z")
Thank you! Later Mark has reported that it is a bug. ---
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 10, 2020, 11:21am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/7 "2020-05-10T11:21:35Z")
Thank you! Mark has reported that it is a bug, so I hope they will fix it. I have experimented some problems with dates in Spanish format. If the app is just for my internal use, I don’t have problem using US format, but when I want Spanish people to work with that… I would prefer everything in Spanish format 😀 Thank you again! ---
**Author:** ![Aj2666](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aj2666/32/1822_2.png) [@Aj2666](https://community.glideapps.com/u/Aj2666)\ **Post date:** [May 11, 2020, 6:08am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/8 "2020-05-11T06:08:54Z")
Correct! I reported it a while back! > [@Date & Time are incorrectly displayed when used as a filter](https://community.glideapps.com/t/date-time-are-incorrectly-displayed-when-used-as-a-filter/7237): > > Hi, Trying to use the “product order date & time” as a filter in the App, but the date gets displayed incorrectly by the filter function while in the “product order date & time” in the data mode is displayed correctly, as shown in the attached image. ---
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 11, 2020, 11:05am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/9 "2020-05-11T11:05:08Z")
So, the bug is not just because the Spanish date format… 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:** [May 11, 2020, 11:37am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/10 "2020-05-11T11:37:36Z")
Glad to help! Agreed that there are still a few areas within Glide that could benefit by more robust date/time features/displays (calendar without times, time picker, date calculations, etc.). ---
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 11, 2020, 3:34pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/11 "2020-05-11T15:34:21Z")
Yes, that is the point. ---
**Author:** ![Yana\_Petiet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yana_petiet/32/10875_2.png) [@Yana\_Petiet](https://community.glideapps.com/u/Yana_Petiet)\ **Post date:** [July 19, 2020, 7:28am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/12 "2020-07-19T07:28:52Z")
hey! having the same problem. could you tell in more detail how this works and if it solved the problem? thanks! ---
**Author:** ![Tatyana\_Fedotova](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tatyana_fedotova/32/5659_2.png) [@Tatyana\_Fedotova](https://community.glideapps.com/u/Tatyana_Fedotova)\ **Post date:** [July 19, 2020, 9:31pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/13 "2020-07-19T21:31:47Z")
![изображение](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/95034ac7d30afdc8b5b8a4d9bc49d220b2978b16.png) The same problem than I group data by date (russian date format) ---
**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:** [July 21, 2020, 2:21am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/14 "2020-07-21T02:21:16Z")
@Yana_Petiet, @Tatyana_Fedotova Have you tried setting the the date format in the date column in the glide data editor? ---
**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:** [July 21, 2020, 2:52am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/15 "2020-07-21T02:52:37Z")
Column formats in Grouping will be fixed soon. ---
**Author:** ![Tatyana\_Fedotova](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tatyana_fedotova/32/5659_2.png) [@Tatyana\_Fedotova](https://community.glideapps.com/u/Tatyana_Fedotova)\ **Post date:** [July 21, 2020, 7:54am UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/16 "2020-07-21T07:54:58Z")
Hi, Jeff! Yes, I set it as is on the screenshot - but it didn’t help ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8bb4654dc582412244f57bf515aec705b9f540c9.png) ---
**Author:** ![Gregory](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregory/32/21180_2.png) [@Gregory](https://community.glideapps.com/u/Gregory)\ **Post date:** [February 13, 2021, 1:17pm UTC](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818/17 "2021-02-13T13:17:58Z")
I just had a similar case with ugly dates in the app (but not in the app builder). Jeff’s “[template-trick](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/4)” helped.