# Table customizer

**URL:** <https://forum.inductiveautomation.com/t/table-customizer/5760>\
**Category:** Ignition\
**Created:** [January 29, 2013, 4:19pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760 "2013-01-29T16:19:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [January 29, 2013, 4:19pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760/1 "2013-01-29T16:19:55Z")

</div>

I’m pulling info into a table from a SQL query. The date is coming in a format “2013012203608”. In the table customizer I’m telling that column to use the Date Format of “M/d/yyyy h:mm a” but that doesn’t change the format. How can i change this date format in the table?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 29, 2013, 4:22pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760/2 "2013-01-29T16:22:05Z")

</div>

It is not changing the value displayed because it is not a date. The column is most likely a string. If you click on the dataset view button on the data property of the table, you can see the data type of the column by selecting it. If it is a string you will have to perform a cast in the SQL query:`SELECT CAST(dateCol AS DATETIME)`

---

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [January 29, 2013, 4:34pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760/3 "2013-01-29T16:34:16Z")

</div>

the column is a double

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 29, 2013, 5:17pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760/4 "2013-01-29T17:17:16Z")

</div>

Ok, you do have to convert it to a date field so you can use our date format.

---

<div class="post-metadata">

**Author:** ![rcorkern](https://avatars.discourse-cdn.com/v4/letter/r/90db22/32.png) [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\
**Post date:** [January 29, 2013, 5:25pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760/5 "2013-01-29T17:25:18Z")

</div>

Ok. That column is now a ‘date’. When I change the date format it displays the format correctly then quickly switches back to the double format. When I check the column properties it changed it back to a double…?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 29, 2013, 5:26pm UTC](https://forum.inductiveautomation.com/t/table-customizer/5760/6 "2013-01-29T17:26:51Z")

</div>

Yes because you have to convert it from the SQL query. When the query runs again it creates a whole new dataset with a double column.