# Table component showing decimal value

**URL:** <https://forum.inductiveautomation.com/t/table-component-showing-decimal-value/97551>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 21, 2024, 3:33pm UTC](https://forum.inductiveautomation.com/t/table-component-showing-decimal-value/97551 "2024-10-21T15:33:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![henrique\_pereira](https://avatars.discourse-cdn.com/v4/letter/h/41988e/32.png) [@henrique\_pereira](https://forum.inductiveautomation.com/u/henrique_pereira)\
**Post date:** [October 21, 2024, 3:33pm UTC](https://forum.inductiveautomation.com/t/table-component-showing-decimal-value/97551/1 "2024-10-21T15:33:47Z")

</div>

Hello, I'm try to query a table and I need to see te column "creation\_date" as data time.  
In dataset editor the values are ok, but in a component table as show like a decimal

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

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [October 21, 2024, 3:41pm UTC](https://forum.inductiveautomation.com/t/table-component-showing-decimal-value/97551/2 "2024-10-21T15:41:36Z")

</div>

Configure the columns in the table's `columns` property, and set the render method of your datetime columns to `date`.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/6/165057dee02985caf1083f76e2edf545c09b24f3.png)

/!\ Don't forget to set the `field` property of each column ! /!\

---

<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:** [October 21, 2024, 3:43pm UTC](https://forum.inductiveautomation.com/t/table-component-showing-decimal-value/97551/3 "2024-10-21T15:43:50Z")

</div>

You need to define the table component's `columns` properties and set the field name of each column to match the dataset column name.  
Then set `column.n.render` to date.  
Then set `column.n.dateFormat` if required.

---

<div class="post-metadata">

**Author:** ![henrique\_pereira](https://avatars.discourse-cdn.com/v4/letter/h/41988e/32.png) [@henrique\_pereira](https://forum.inductiveautomation.com/u/henrique_pereira)\
**Post date:** [October 21, 2024, 4:10pm UTC](https://forum.inductiveautomation.com/t/table-component-showing-decimal-value/97551/4 "2024-10-21T16:10:51Z")

</div>

> [@Transistor](#):
>
> `n.render` `column.n.dateFormat`

TKS Sir, U are the best