# 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:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkizerian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dkizerian/32/28623_2.png) [@dkizerian](https://community.glideapps.com/u/dkizerian)\
**Post date:** [July 3, 2021, 2:50pm UTC](https://community.glideapps.com/t/converting-multiple-dates-into-usable-data/28671/1 "2021-07-03T14:50:18Z")

</div>

Hi,  
I’m building an app that uses data output by another system that I don’t have any control over.  
This system outputs dates as a string that looks like this “ 2021-07-30,2021-07-31,2021-08-01”. Each output will have between 1 and 3 dates in it.

I’d like to be able to work with these dates individually, and be able to calculate what day of the week each one is. Basically I’d like to be able to to display “Friday, 7/30” or similar.

I’ve played with Split Text, but can’t figure out what to do with the data once split.

Thanks

---

<div class="post-metadata">

**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:** [July 3, 2021, 8:14pm UTC](https://community.glideapps.com/t/converting-multiple-dates-into-usable-data/28671/2 "2021-07-03T20:14:17Z")

</div>

You have to split it in Google sheets, glide split function is not good for this.

---

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