# Datetime in table column showing only int value after update to 8.0.14

**URL:** <https://forum.inductiveautomation.com/t/datetime-in-table-column-showing-only-int-value-after-update-to-8-0-14/36759>\
**Category:** Ignition\
**Tags:** database, perspective\
**Created:** [July 16, 2020, 11:35am UTC](https://forum.inductiveautomation.com/t/datetime-in-table-column-showing-only-int-value-after-update-to-8-0-14/36759 "2020-07-16T11:35:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![janne.p](https://avatars.discourse-cdn.com/v4/letter/j/7ea924/32.png) [@janne.p](https://forum.inductiveautomation.com/u/janne.p)\
**Post date:** [July 16, 2020, 11:35am UTC](https://forum.inductiveautomation.com/t/datetime-in-table-column-showing-only-int-value-after-update-to-8-0-14/36759/1 "2020-07-16T11:35:37Z")

</div>

I have problem with dateformatting. In previous version it worked normally but after update the value is not showing corectly

Value in SQL database is “date” datatype and Named query preview shows the right value.

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

In the UI when using table shows value incorrecty after update

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

Older version 8.0.9 works fine and the update was made to version 8.0.14

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

What could be possible reasons to this kind of behaviour?

---

<div class="post-metadata">

**Author:** ![ijustdunnoaname1](https://avatars.discourse-cdn.com/v4/letter/i/c67d28/32.png) [@ijustdunnoaname1](https://forum.inductiveautomation.com/u/ijustdunnoaname1)\
**Post date:** [July 16, 2020, 12:01pm UTC](https://forum.inductiveautomation.com/t/datetime-in-table-column-showing-only-int-value-after-update-to-8-0-14/36759/2 "2020-07-16T12:01:57Z")

</div>

I just ran into this recently as well. For that table, add a transform script:

return system.dataset.formatDates(value,“MM/dd/yyyy”)