# \[IGN-5540\] Perspective Table renders this.props.data\[0\] datetime value as text in props.selection.data\[0\] **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [September 22, 2020, 7:36pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951 "2020-09-22T19:36:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\ **Post date:** [September 22, 2020, 7:36pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/1 "2020-09-22T19:36:48Z")
The table has props.data like so ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/a/fac9a33c4c97155c485e42b68e5aad0590c8f4b6.png) I am trying to call a pop-up and I need to use the timeE field as a param in it. But when I use the props.selected.data[0] to pass the info in its structure is in text. I realize I can use the index of the selected row and get from there and that is what I am doing. But, what if I needed multiple rows. Shouldn’t it come through as a DateTime value? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/3/23b95169d5dd4a2b1e40698823fe44e46e04143e.png) ---
**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\ **Post date:** [October 1, 2021, 7:20pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/2 "2021-10-01T19:20:55Z")
I’m experiencing this issue in 8.1.6; is this still present in 8.1.10? props.selected.data is rendering dates as strings. props.data: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/4493b535bbfda91c85777f606ab7654540b2fce3.png) props.selection.data: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/0/2008715e56f0f6af605d1c57926be8c319cc7376.png) ---
**Author:** ![kelly.draehn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kelly.draehn/32/21474_2.png) [@kelly.draehn](https://forum.inductiveautomation.com/u/kelly.draehn)\ **Post date:** [February 8, 2022, 6:33pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/3 "2022-02-08T18:33:55Z")
Did anyone find a fix for this? I’m having the same issue here and it is keeping my update query from functioning ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [February 8, 2022, 7:21pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/4 "2022-02-08T19:21:44Z")
That shouldn’t be happening. I’ve opened an internal ticket to address the issue, but I have no timeframe for a fix. ---
**Author:** ![kelly.draehn](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kelly.draehn/32/21474_2.png) [@kelly.draehn](https://forum.inductiveautomation.com/u/kelly.draehn)\ **Post date:** [February 8, 2022, 7:49pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/5 "2022-02-08T19:49:09Z")
No worries! I did a workaround by adding another column with the date in millis and hid it. Then when passing the selection I had access to that which came over as an int just fine. Seems like an easy workaround for now. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 10, 2024, 4:44am UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/6 "2024-07-10T04:44:32Z")
I'm having this issue in 8.1.39. My database is PostgreSQL 15 My date column is timestamptz ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f357a65279a3a5091f8589d1e3741b5a02551086.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/7/f731582b8ab57f6b6ea5c3fc23878d5f9038ba69.png) It's a bit of effort for me to add the millis into the resurned data as there's a lot of dynamically created stuff... hoping that I can parse this ugly date/time format automatically to convert it back in my script... 😬 Edit: parsing that time format seems harder than I thought, that and also it's probably showing the local browser's locale format as well in which case it might be different on every client... 😕 ---
**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Post date:** [August 29, 2024, 8:15am UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/7 "2024-08-29T08:15:58Z")
Same issue here **Ignition 8.1.31**. This issue is affecting also in place editing, i.e. if the datetime cell is double-clicked for edit, the user is presented with the following odd date/time: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/7/774407bd8e88b8c09586ac70276ca08df504d4b5.png) @cmallonee any timeframe for a fix yet? Thanks, regards ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [August 29, 2024, 3:45pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/8 "2024-08-29T15:45:47Z")
No estimate as the ticket is still awaiting development. I'll update the ticket with the additional traffic. ---
**Author:** ![pgmo](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Post date:** [September 3, 2024, 1:07pm UTC](https://forum.inductiveautomation.com/t/ign-5540-perspective-table-renders-this-props-data-0-datetime-value-as-text-in-props-selection-data-0/38951/9 "2024-09-03T13:07:24Z")
Ok, thanks @cmallonee