# T\_stamp formatting

**URL:** <https://forum.inductiveautomation.com/t/t-stamp-formatting/93140>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 12, 2024, 1:14pm UTC](https://forum.inductiveautomation.com/t/t-stamp-formatting/93140 "2024-07-12T13:14:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sawyer\_Jones](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@Sawyer\_Jones](https://forum.inductiveautomation.com/u/Sawyer_Jones)\
**Post date:** [July 12, 2024, 1:14pm UTC](https://forum.inductiveautomation.com/t/t-stamp-formatting/93140/1 "2024-07-12T13:14:28Z")

</div>

Hello, I'm currently designing a perspective program that shows you when historized Boolean tags change. I've gotten it to work up to the point where in my perspective table it shows me when but the t\_stamp column is unreadable. I've tried a bunch of stuff, but nothings worked so far. Any help is greatly appreciated.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 12, 2024, 1:32pm UTC](https://forum.inductiveautomation.com/t/t-stamp-formatting/93140/3 "2024-07-12T13:32:17Z")

</div>

Ignition datetime objects, `java.util.Date` instances, do not have a javascript equivalent. Under the hood, they are UTC milliseconds from Jan 1, 1970. To not lose information, they are transmitted to the browser as 64-bit integers.

Components in Perspective that expect such objects (date pickers, in particular) expect this substitution and convert to/from user formats automatically.

The Perspective table, because it can display actual long integers too, needs an extra clue from you, the designer, for columns of this type. Simply change the `props.columns[...].render` setting for that column from "auto" to "date".

---

<div class="post-metadata">

**Author:** ![Sawyer\_Jones](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@Sawyer\_Jones](https://forum.inductiveautomation.com/u/Sawyer_Jones)\
**Post date:** [July 12, 2024, 1:50pm UTC](https://forum.inductiveautomation.com/t/t-stamp-formatting/93140/4 "2024-07-12T13:50:17Z")

</div>

I just tried that in the props. It didn't work. I'm also running 8.1.16, which I know it's relatively out of date. Would screen shots of my code and perspective props help?

---

<div class="post-metadata">

**Author:** ![Sawyer\_Jones](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@Sawyer\_Jones](https://forum.inductiveautomation.com/u/Sawyer_Jones)\
**Post date:** [July 12, 2024, 1:54pm UTC](https://forum.inductiveautomation.com/t/t-stamp-formatting/93140/5 "2024-07-12T13:54:59Z")

</div>

Never mind. I forgot to input the field value. This was great help thank you!