Converting multiple dates into usable data

Ask for Help
1

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

2

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

3

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 :arrow_down:

2 Likes