# Changing Data format in Glide Table

**URL:** <https://community.glideapps.com/t/changing-data-format-in-glide-table/28670>\
**Category:** Ask for Help\
**Created:** [July 3, 2021, 2:36pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670 "2021-07-03T14:36:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)\
**Post date:** [July 3, 2021, 2:36pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/1 "2021-07-03T14:36:33Z")

</div>

Hi everyone,  
is there any possibility to have the Date column in Glide Table in this format - mm/yyyy ?  
Shortest format is now mm/dd/yyyy…

Thank you,  
M.V.

---

<div class="post-metadata">

**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:** [July 3, 2021, 2:41pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/2 "2021-07-03T14:41:36Z")

</div>

No, not directly - which I find a constant source of annoyance.

If you want a specific date format for display in your app, then you need to construct a string that matches the desired format with a combination of math and template columns. Essentially, you need to deconstruct the date into its year/month/day components, and then piece them back together again.

---

<div class="post-metadata">

**Author:** ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)\
**Post date:** [July 3, 2021, 3:11pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/3 "2021-07-03T15:11:57Z")

</div>

Can you give me an ideea ? I deconstructed the date with Split Text, now what ?

---

<div class="post-metadata">

**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:** [July 3, 2021, 3:25pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/4 "2021-07-03T15:25:15Z")

</div>

Split Text won’t help you. As I mentioned, you need to use math and template columns.

Assume your date is in a column called “date”:

- Math column with the formula `Year(date)` - this will give you the year
- Math column with the formula `Month(date)` - this will give you the month number
- If you need a leading zero with the month number, then you’ll need an if-then-else column:
  - if month number \< 10 then 0, else blank

- Then put it together with a template column: `{pad}{month}/{year}`, where:
  - {pad} is the output of the if-then-else column,
  - {month} is the output of the second math column, and
  - {year} is the output of the first math column

 ![Screen Shot 2021-07-03 at 11.24.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/81aa78c0c2dd50b1fac1c08b5baff332e09d836d.png)

---

<div class="post-metadata">

**Author:** ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)\
**Post date:** [July 3, 2021, 3:29pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/5 "2021-07-03T15:29:51Z")

</div>

You made my day ! 👍

---

<div class="post-metadata">

**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 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/6 "2024-01-17T16:51:39Z")

</div>