# Issue with Perspective Table Showing seconds since epoch instead of formatted date

**URL:** <https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [June 11, 2019, 5:17pm UTC](https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734 "2019-06-11T17:17:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mitchell-ACS](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mitchell-acs/32/30062_2.png) [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\
**Post date:** [June 11, 2019, 5:17pm UTC](https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734/1 "2019-06-11T17:17:22Z")

</div>

I have a table in perspective thats supposed to be showing me a date in a column, but instead it seems to be showing seconds since the epoch.  
I have the column render set to date, and the format specified but it doesn’t seem to change anything.

 ![01%20AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/56aed5de79ac08835105f12d7041958025fee968.png) ![15%20AM](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b17b95eec82c99305062dd36305805d0dbe35cfc.png)

---

<div class="post-metadata">

**Author:** ![jcoffman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jcoffman/32/6429_2.png) [@jcoffman](https://forum.inductiveautomation.com/u/jcoffman)\
**Post date:** [June 11, 2019, 7:44pm UTC](https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734/2 "2019-06-11T19:44:09Z")

</div>

Thanks for reporting this.  
This is a known issue that has a fix already in the code base that will be in the 8.0.3 version.

Thanks,  
Jonathan C

---

<div class="post-metadata">

**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\
**Post date:** [March 23, 2021, 3:24pm UTC](https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734/3 "2021-03-23T15:24:01Z")

</div>

in v8.0.16 it doesn`t work

---

<div class="post-metadata">

**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\
**Post date:** [March 23, 2021, 3:24pm UTC](https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734/4 "2021-03-23T15:24:32Z")

</div>

I can`t change format! How I can do it?

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [March 23, 2021, 4:23pm UTC](https://forum.inductiveautomation.com/t/issue-with-perspective-table-showing-seconds-since-epoch-instead-of-formatted-date/25734/5 "2021-03-23T16:23:29Z")

</div>

> [@Andrii.Randiuk](#):
>
> in v8.0.16 it doesn`t work

It does work in 8.0.16.

Please verify that you have a column configuration in place for the column which contains your date.

In the following screenshots, I'm using a Dataset with columns named "str" and "Date".

No column configuration specified for the column (`field` setting is empty):

 ![Screen Shot 2021-03-23 at 9.19.05AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/9/39fe60828eb6c9406c976b3a0a24156e5169bdba.png)

Now the `field` property is correctly specified to target my column named "Date" (you can see that the column is now rendered correctly):

 ![Screen Shot 2021-03-23 at 9.19.20AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3adc65b8a2bed70b6bee14027757e68070257539.png)

After changing the `dateFormat` property to render as date and time:

 ![Screen Shot 2021-03-23 at 9.19.33AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/a/5ab9cd2d7a3798ab89d94cf48b4a469a29df4338.png)