Hi All,
I’m new to Coda and have a question I’m hoping someone can help me with.
I have a set of data being pulled into Coda from Jira via Zapier.
Within the data is a column with cells that each contain data that looks like this:
2018-07-03T20:10:34.313-0400,2018-07-03T21:05:35.157-0400,2018-07-10T03:12:17.728-0400,2018-07-10T13:33:07.999-0400,2018-07-12T06:01:58.492-0400,2018-07-12T06:15:57.785-0400
This data is actually the cumulative dates, times (and unknown) (2018-07-12T06:15:57(.785-0400<-unknown) of comment data. I am trying to identify the date and time of the last comment made.
Anyway, what I am trying to do is write a formula that reads and parses the last entry into a date and time for each cell.
The first thing I would like a hand with is: How do I reference the last entry in each cell and have that last entry display in the cell?
Second would be, how could I parse the Last entry so I had a date and time result (I can probably work this part out on my own).
Any advice would be greatly appreciated.
Kind regards,
Sean.