# Converting multiple dates into usable data

**URL:** https://community.glideapps.com/t/converting-multiple-dates-into-usable-data/28671
**Category:** Ask for Help
**Created:** [July 3, 2021, 2:50pm UTC](https://community.glideapps.com/t/converting-multiple-dates-into-usable-data/28671 "2021-07-03T14:50:18Z")
**Posts on this page:** 1
**Showing post:** 3

<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 4, 2021, 4:13am UTC](https://community.glideapps.com/t/converting-multiple-dates-into-usable-data/28671/3 "2021-07-04T04:13:28Z")

</div>

I agree with @uzo. This is probably a case where using a spreadsheet formula to first split your input into separate date columns is a good approach. However, I’d still do the date formatting using Glide computed columns. For an example of how this can be done, see below ⬇

> [@Changing Data format in Glide Table](https://community.glideapps.com/t/changing-data-format-in-glide-table/28670/4):
>
> 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} i…

---

_[View the full topic](https://community.glideapps.com/t/converting-multiple-dates-into-usable-data/28671)._