# Ignition Perspective Table component

**URL:** <https://forum.inductiveautomation.com/t/ignition-perspective-table-component/54041>\
**Category:** Ignition\
**Tags:** ignition80, ignition81, database, perspective\
**Created:** [December 13, 2021, 12:32pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table-component/54041 "2021-12-13T12:32:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![subramaniam.gopal](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@subramaniam.gopal](https://forum.inductiveautomation.com/u/subramaniam.gopal)\
**Post date:** [December 13, 2021, 12:32pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table-component/54041/1 "2021-12-13T12:32:39Z")

</div>

Ignition Perspective Table component column not showing correct date format from database

Dataset showing correct date format

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/0631cb98b07201737c8897a4de6c9cdc55263bfe.png)

however table display showing not readable format

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

please advise how to change the setting it to readable date format

---

<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:** [December 13, 2021, 12:43pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table-component/54041/2 "2021-12-13T12:43:42Z")

</div>

On `PROPS.columns` set the field property for each column to the column name. Then select the `render` to ‘date’.

Note that this procedure allows you to reorder the columns in the table differently to that supplied by the database query.

---

<div class="post-metadata">

**Author:** ![subramaniam.gopal](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@subramaniam.gopal](https://forum.inductiveautomation.com/u/subramaniam.gopal)\
**Post date:** [December 13, 2021, 12:53pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-table-component/54041/3 "2021-12-13T12:53:54Z")

</div>

Thanks