# Date & Time Format Issues **URL:** \ **Category:** Ask for Help\ **Created:** [December 21, 2022, 8:25am UTC](https://community.glideapps.com/t/date-time-format-issues/55931 "2022-12-21T08:25:36Z")\ **Posts on this page:** 9\ **Page:** 2
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 21, 2022, 12:09pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/21 "2022-12-21T12:09:34Z")
Okay cool, interesting method. ---
**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:** [December 21, 2022, 12:14pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/22 "2022-12-21T12:14:30Z")
> [@ToOFa\_Apps](#): > > I did try the math and template method but my Month (Date) shows as a number, how would i get the month to show as text eg. December You need a list of months in a table somewhere, eg: - January - February - March - etc And then the Month(Date) value to take a Single Value-\>from Start from that list. If using that method, you need to adjust the math formula slightly: `Month(Date)-1` ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 21, 2022, 12:18pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/23 "2022-12-21T12:18:02Z")
or just use format date MMMM 😉 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 21, 2022, 12:35pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/24 "2022-12-21T12:35:10Z")
I entered manually, in different ways… and my method works all the time… Glide math column is the best ![Screen Shot 2022-12-21 at 7.33.44 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b75c160b5a2142043769960e4e02f3733e1f847.png) then switch column to a date ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 21, 2022, 12:42pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/25 "2022-12-21T12:42:23Z")
Thanks for all the help on this. Date and time is so temperamental on sheets as well, as long as there is a fool proof way to achieve the desired results i’m happy no matter what method. Maybe they’ll fix the Format Date Plugin sometime🙏 ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 21, 2022, 2:57pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/26 "2022-12-21T14:57:24Z")
I still encountered issues with your method Darren. The problem is that glide components still don’t seem to regard the formatted time as date/time so it doesn’t give condition options such as “is on or after today” etc. I tried Uzo’s method and it all works, and i get the date/time options for components. I’m using both methods for further testing These screenshots show the difference for the components options. ![Screenshot 2022-12-21 at 15.18.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3a2674d082270a5e1be425bbabe11fb77436cd7.png) ![Screenshot 2022-12-21 at 16.54.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c2781f5524f32b751d2a33a12fff647a1f896f5.png) ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 21, 2022, 3:01pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/27 "2022-12-21T15:01:15Z")
Here are some screen shots for the solution. ![Screenshot 2022-12-21 at 16.35.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d12ca6aa1f1d9301ac79b2df20ab3b9cf85fac3.png) ![Screenshot 2022-12-21 at 16.36.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d81be74a003286711d4571fb0f95faf7364443f1.jpeg) ![Screenshot 2022-12-21 at 16.36.43](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1a96e5b43a555ef5bb6d9d44a9a8c900ae0871e0.jpeg) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 21, 2022, 3:11pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/28 "2022-12-21T15:11:52Z")
yep, it works great! I’m very impressed with how well… I tried to enter the date in so many different ways as a text… and it figure out! Great job Glide with the math column! I would recommend that everybody use this technique, for all dates that come from other sources than Glide date picker… even if it looks like everything is ok. ---
**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:** [December 21, 2022, 3:17pm UTC](https://community.glideapps.com/t/date-time-format-issues/55931/29 "2022-12-21T15:17:26Z")
> [@ToOFa\_Apps](#): > > The problem is that glide components still don’t seem to regard the formatted time as date/time so it doesn’t give condition options such as “is on or after today” etc. Yes, that’s expected because my method converts the date into a number. Anyway, it sounds like Uzo’s method is going to work best for your use case. That’s the nice thing about Glide - for any given problem there’s often several different ways to approach a solution. And which is best usually depends on the specific use case. [Previous page](https://community.glideapps.com/t/date-time-format-issues/55931.md?page=1)