# Perspective Table with named query data type issue

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-with-named-query-data-type-issue/89180>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 22, 2024, 4:23am UTC](https://forum.inductiveautomation.com/t/perspective-table-with-named-query-data-type-issue/89180 "2024-04-22T04:23:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\
**Post date:** [April 22, 2024, 4:23am UTC](https://forum.inductiveautomation.com/t/perspective-table-with-named-query-data-type-issue/89180/1 "2024-04-22T04:23:16Z")

</div>

Hi, I'm using the table component in perspective to show the my named query result, In this my "assign\_date" column information not showing the result in correct format.  
Actually it need show the date & time.  
Please give me some suggestion. Thanks.

 ![Table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/d/2df81fc5621a03d637c874dc8ea3e3760774d9a4.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 22, 2024, 7:41am UTC](https://forum.inductiveautomation.com/t/perspective-table-with-named-query-data-type-issue/89180/2 "2024-04-22T07:41:59Z")

</div>

- For each column set `columns.x.field` to the exact name of the column in `props.data`.
- For the `assign_date` column set,  
`columns.x.field : assign_date`  
`columns.x.render : date`  
`columns.x.dateFormat : YYYY-MM-DD HH:mm:ss` (or whatever you want).

Many of the column properties don't work unless you specify the column's field property.

---

<div class="post-metadata">

**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\
**Post date:** [April 22, 2024, 8:09am UTC](https://forum.inductiveautomation.com/t/perspective-table-with-named-query-data-type-issue/89180/3 "2024-04-22T08:09:54Z")

</div>

Thanks!