# Showing just the date **URL:** \ **Category:** Ask for Help\ **Created:** [December 9, 2020, 5:17pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624 "2020-12-09T17:17:53Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [December 9, 2020, 5:17pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/1 "2020-12-09T17:17:53Z")
I have a section in my app where teachers can set the assigned and due dates. It show fine in the Teachers tab where they are making the assignment using a date component. Problem is that on the Assignments tab I have made a table to show these dates but I can only get them showing as date/time. Do not want the time showing. Anyway around this? ![Screen Shot 2020-12-09 at 1.17.27 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26e8aa55b226527c801799b3f35ea7eaf51ae78b.png) ---
**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:** [December 9, 2020, 6:54pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/2 "2020-12-09T18:54:27Z")
@Todd_Lichtenwalter maybe this is the answer > [@Ugly Date in If-then-else](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/4): > > Usually creating a template column of the date column will “lock in” that formatting. Then you can use the template column in your if then column. Haven’t had chance to play around so it may or may not work or try editing the date format in the glide column as date only. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [December 9, 2020, 6:58pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/3 "2020-12-09T18:58:30Z")
Have you tried editing the date in the Glide Data Editor to date only? ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [December 9, 2020, 7:33pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/4 "2020-12-09T19:33:34Z")
That did it. I was trying in the wrong place. Thank you Manan! ---
**Author:** ![Ray](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ray/32/4727_2.png) [@Ray](https://community.glideapps.com/u/Ray)\ **Post date:** [April 12, 2021, 1:35pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/5 "2021-04-12T13:35:57Z")
For me the issue is vice versa: Edited Date&Time, picker only grabs date…?! 🤪 Any idea anyone? ---
**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 12, 2021, 2:12pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/6 "2021-04-12T14:12:34Z")
@Ray > [@Manan\_Mehta](#): > > Have you tried editing the date in the Glide Data Editor to date only? Have you done this in the data editor, but change the column formatting to show date and time instead? ---
**Author:** ![Ray](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ray/32/4727_2.png) [@Ray](https://community.glideapps.com/u/Ray)\ **Post date:** [April 12, 2021, 2:25pm UTC](https://community.glideapps.com/t/showing-just-the-date/19624/7 "2021-04-12T14:25:44Z")
… 🙄 my stupid mistake…chose the date component instead date&time component…sorry and thanks… ---
**Author:** ![habao213](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/habao213/32/33067_2.png) [@habao213](https://community.glideapps.com/u/habao213)\ **Post date:** [March 12, 2022, 3:23am UTC](https://community.glideapps.com/t/showing-just-the-date/19624/8 "2022-03-12T03:23:36Z")
You can create a new column with “Format Date” type. Then, select Date =\> Date Variable , Format =\> DD. Done. Hope this help. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 12, 2022, 3:38am UTC](https://community.glideapps.com/t/showing-just-the-date/19624/9 "2022-03-12T03:38:52Z")
The Format Date plugin is known to be unreliable. Using it is not recommended, especially for non-US locales. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 12, 2024, 1:50am UTC](https://community.glideapps.com/t/showing-just-the-date/19624/10 "2024-01-12T01:50:00Z")