# V8.1.2 Perspective View Table: Tag History, TimeStamp display format

**URL:** <https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905>\
**Category:** General Discussion\
**Created:** [January 3, 2021, 1:30am UTC](https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905 "2021-01-03T01:30:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CIM](https://avatars.discourse-cdn.com/v4/letter/c/67e7ee/32.png) [@CIM](https://forum.inductiveautomation.com/u/CIM)\
**Post date:** [January 3, 2021, 1:30am UTC](https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905/1 "2021-01-03T01:30:30Z")

</div>

In Perspective, I binding a tag history to “table.props.data”, and the table shows 4 columns path, value, quality, timestamp, but timestamp is showing a big integer not the format of datetime as shown in the dataset (Edit Dataset right to “table.props.data” binding.

In the Vision and I created a table but it shows the timestamp in DateTime format!

Any help to format the table columns in the Perspective?

Thanks!

---

<div class="post-metadata">

**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:** [January 3, 2021, 10:34am UTC](https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905/2 "2021-01-03T10:34:25Z")

</div>

The timestamp is probably showing Unix epoch time. From memory you can tell the table that the column is a datetime field.

---

<div class="post-metadata">

**Author:** ![CIM](https://avatars.discourse-cdn.com/v4/letter/c/67e7ee/32.png) [@CIM](https://forum.inductiveautomation.com/u/CIM)\
**Post date:** [January 4, 2021, 10:11pm UTC](https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905/3 "2021-01-04T22:11:52Z")

</div>

It is Unix epoch time, but I cannot set it to DateTime format. I added column array elements in the property editor of the table, tried changing the settings, seems ‘render’ has the date settings but not work.

---

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [January 4, 2021, 10:27pm UTC](https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905/4 "2021-01-04T22:27:41Z")

</div>

make sure field is set. You can tell when column is mapped cause the sorting icons up and down appear next to header name.

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

---

<div class="post-metadata">

**Author:** ![CIM](https://avatars.discourse-cdn.com/v4/letter/c/67e7ee/32.png) [@CIM](https://forum.inductiveautomation.com/u/CIM)\
**Post date:** [January 4, 2021, 10:43pm UTC](https://forum.inductiveautomation.com/t/v8-1-2-perspective-view-table-tag-history-timestamp-display-format/41905/5 "2021-01-04T22:43:31Z")

</div>

Ok, I got it. I didn’t set the field.

Thank you wking!