# Perspective Table t\_stamp format

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 27, 2021, 9:13pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466 "2021-12-27T21:13:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![EMarsupial](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@EMarsupial](https://forum.inductiveautomation.com/u/EMarsupial)\
**Post date:** [December 27, 2021, 9:13pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466/1 "2021-12-27T21:13:52Z")

</div>

I’m using a named query to supply the data to my table. In the dataset the format looks correct, but in the table it does not. How can I fix that?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/6/5674869668765c620006ae787b66e2fd639a878d.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/c/5c6191c934cf802d90ef2ba749f97b9d825b2b3a.png)

---

<div class="post-metadata">

**Author:** ![dstolbov](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dstolbov/32/26615_2.png) [@dstolbov](https://forum.inductiveautomation.com/u/dstolbov)\
**Post date:** [December 27, 2021, 9:23pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466/2 "2021-12-27T21:23:05Z")

</div>

Consider using ‘columns’ property on table component. Under column configurations, changing ‘render’ property will allow you to implicitly render data as certain data type.

---

<div class="post-metadata">

**Author:** ![EMarsupial](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@EMarsupial](https://forum.inductiveautomation.com/u/EMarsupial)\
**Post date:** [December 28, 2021, 5:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466/3 "2021-12-28T17:31:06Z")

</div>

I had to add the column and name it appropriately in order for the date to work in the field property. Thank you!

---

<div class="post-metadata">

**Author:** ![Hazmat480](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\
**Post date:** [May 26, 2022, 1:50pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466/4 "2022-05-26T13:50:32Z")

</div>

I am having similar issues. Adding the column and changing the render and datefromat didn’t seem to have any affect.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/7/371f4528b3479d5f6b42da19886d2a51e489af3a.png)

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [May 26, 2022, 1:56pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466/5 "2022-05-26T13:56:49Z")

</div>

change you columns[0].field to t\_stamp.

It seems that render selection only works if there is a valid field assigned.

---

<div class="post-metadata">

**Author:** ![Hazmat480](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\
**Post date:** [May 26, 2022, 3:08pm UTC](https://forum.inductiveautomation.com/t/perspective-table-t-stamp-format/54466/6 "2022-05-26T15:08:48Z")

</div>

Thanks for some reason I tried that originally and it didn’t work. It is working now. Appreciate the help.