# Perspective table displaying unix epoch date but not in dataset? **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [October 4, 2021, 6:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588 "2021-10-04T18:31:44Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [October 4, 2021, 6:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588/1 "2021-10-04T18:31:44Z")
Using SQL Server 2019 and Perspective 8.1.10. I have a named query that gets a datetime field from SQL Server. The datetime appears correct in the dataset. When I bind the dataset from my named query to the table, it comes in as unix epoch time however. I have not changed anything about the table formatting. It looks like this ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b6631aa28bb4dba1acda9b03559c716f738354d.png) I have set “render” for this column to “date” and the “dateFormat” to 'MM/DD/YYYY` but I am seeing these unix dates in the table still. Any idea what I am doing wrong? ---
**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Post date:** [October 4, 2021, 6:34pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588/2 "2021-10-04T18:34:02Z")
Make sure the `field` property in your column config matches the column name in your dataset exactly. This behavior usually happens when there is no corresponding column config for that column. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [October 4, 2021, 6:38pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588/3 "2021-10-04T18:38:03Z")
Wow right off the bat, thanks that did it. ---
**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Post date:** [October 4, 2021, 7:29pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588/4 "2021-10-04T19:29:34Z")
😆 was it obvious I have run into that one a few times? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [October 5, 2021, 6:21pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588/5 "2021-10-05T18:21:42Z")
> [@bkarabinchak.psi](#): > > MM/DD/YYYY There's your issue, it should be either yyyy-MM-dd or dd-MM-yyyy to join the rest of the world 😁 (and ISO 8601 standard) ---
**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Post date:** [October 15, 2021, 1:11pm UTC](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588/6 "2021-10-15T13:11:34Z")
![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/9/0968eacd9ee1ef426d2bb5b3ec1ba22f7bf851c1.png)