# Display Date in different formats **URL:** \ **Category:** Ask for Help\ **Created:** [February 16, 2022, 3:08pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578 "2022-02-16T15:08:47Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [February 16, 2022, 3:08pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/1 "2022-02-16T15:08:47Z")
This might be a stupid question, but… I have a date column in Glide, and sometimes I’d like to display it as date only and other times as date+time. I can’t seem to figure out how to do that, I tried to create a TEMPLATE that is just the date, but then it just adopts the display format of the original date column. I could construct it in a TEMPLATE with MATH columns MONTH(date)-DAY(date) -YEAR(date), but then I don’t benefit from automatic international locales. Obviously, I could create a copy in Sheets with an ARRAYFORMULA, but that seems a bit silly… Any suggestions on how to do this in Glide ? ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [February 16, 2022, 3:10pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/2 "2022-02-16T15:10:34Z")
You can use the luxon date plugin: > **[Format Date column • Glide](https://www.glideapps.com/plugins/format-date)** > > Powerful date & time formatting with luxon. ---
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [February 16, 2022, 3:23pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/3 "2022-02-16T15:23:33Z")
Awesome, thanks ! ---
**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:** [February 16, 2022, 4:04pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/4 "2022-02-16T16:04:30Z")
> [@Killko](#): > > I have a date column in Glide, and sometimes I’d like to display it as date only and other times as date+time. Probably the simplest way to do that is to use a single math column and format it as time only. ![Screen Shot 2022-02-17 at 12.00.40 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/7522d9d2a273317b60bdfe880baadf494e357964.png) The Format Date plugin is tempting, but beware - the underlying Luxon library is buggy and unreliable and is known to have issues with non-US date format/locales, especially with Safari on IOS. Personally, I do not use it and I don’t recommend using it. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 16, 2022, 11:38pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/5 "2022-02-16T23:38:28Z")
I would suggest the same thing. For any variants of display you want, just make a new math column and change the format. Albeit it’s limited, it offers a much more stable experience than Luxon, which struggles a lot, especially in Safari. ---
**Author:** ![Frankchavezbernal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/frankchavezbernal/32/41891_2.png) [@Frankchavezbernal](https://community.glideapps.com/u/Frankchavezbernal)\ **Post date:** [February 17, 2022, 4:20am UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/6 "2022-02-17T04:20:19Z")
I recommend that you use the Mathematical column since lately the format of date plugins is presenting some problems, so the ideal now is the Mathematical Column. I sent you the link so you can see its functionality and how simple it is > **[Math Column](https://docs.glideapps.com/all/topics/computed-columns/primary/math-column)** > > Performs instant calculations on your data ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 22, 2022, 6:37pm UTC](https://community.glideapps.com/t/display-date-in-different-formats/38578/7 "2022-02-22T18:37:06Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.