# How to convert date string in "table.selection.data" property from Table Component in Perspective

**URL:** <https://forum.inductiveautomation.com/t/how-to-convert-date-string-in-table-selection-data-property-from-table-component-in-perspective/113878>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [February 10, 2026, 5:21pm UTC](https://forum.inductiveautomation.com/t/how-to-convert-date-string-in-table-selection-data-property-from-table-component-in-perspective/113878 "2026-02-10T17:21:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Slick](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@Slick](https://forum.inductiveautomation.com/u/Slick)\
**Post date:** [February 10, 2026, 5:21pm UTC](https://forum.inductiveautomation.com/t/how-to-convert-date-string-in-table-selection-data-property-from-table-component-in-perspective/113878/1 "2026-02-10T17:21:27Z")

</div>

I have a table component in a perspective view that pulls data from a db table and displays it. When the data is pulled, the date values are formatted correctly in the property `table.data` :

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9c4278432d32c7f65c8db21236a850c65d8cd770.png)

However, in the `table.selection.data` property, these same dates are formatted in a long string format:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/5/d53b1f83949b25726e4166822997325cdecd268b.png)

Is there a way to convert these string versions of the data back to date format? Or even better, can I have the `table.selection.data` property have the same format as the `table.data` property for its values?

I tried `system.date.parse()`to convert the strings, but it does not take the long string as input.

Thanks,

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 10, 2026, 5:30pm UTC](https://forum.inductiveautomation.com/t/how-to-convert-date-string-in-table-selection-data-property-from-table-component-in-perspective/113878/2 "2026-02-10T17:30:20Z")

</div>

This is an unfortunate side effect of browsers not actually supporting date/time objects.

The stringified date is also localized to a time zone, complicating parsing.

The robust solution is to include an extra key in the table's `props.data` that is the row index. Then the consumer of the selection data can look up the original row data in the source.

This is also necessary for any row data that has nested objects--those are collapsed and lost in selection data.

---

<div class="post-metadata">

**Author:** ![Slick](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@Slick](https://forum.inductiveautomation.com/u/Slick)\
**Post date:** [February 10, 2026, 7:03pm UTC](https://forum.inductiveautomation.com/t/how-to-convert-date-string-in-table-selection-data-property-from-table-component-in-perspective/113878/4 "2026-02-10T19:03:12Z")

</div>

> [@Slick](#):
>
> ted by author)

Using the rowid as the row index allowed me do what I needed to with the selected rows in the table.

Thank you for the advice!