# 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:** 1\
**Showing post:** 4

<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)

---

_[View the full topic](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670)._