# How to format date inside a table

**URL:** <https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825>\
**Category:** Maker\
**Tags:** perspective\
**Created:** [October 22, 2023, 9:52pm UTC](https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825 "2023-10-22T21:52:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vidar\_Hetlelid](https://avatars.discourse-cdn.com/v4/letter/v/dfb087/32.png) [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\
**Post date:** [October 22, 2023, 9:52pm UTC](https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825/1 "2023-10-22T21:52:59Z")

</div>

Hi there,

I have a table that contain multiple data types. But the date datatypes get formatted like shown below. How can i reformat this to an actual date?

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/5/953b3dd1dd85f20dadb08ea984f1c7fb45328412.png)

In the database its shown like this:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/b/eb3c2a1ac4bcb5d9a9de95cb31a81c403e1176c3.png)

---

<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:** [October 22, 2023, 10:36pm UTC](https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825/2 "2023-10-22T22:36:32Z")

</div>

Configure the `.props.columns` list for your table to call out each column and provide datatype and **rendering** information:

[https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Table#PerspectiveTable-Properties](https://docs.inductiveautomation.com/display/DOC81/Perspective+-+Table#PerspectiveTable-Properties)

[https://docs.inductiveautomation.com/display/DOC81/Table+Column+Configurations](https://docs.inductiveautomation.com/display/DOC81/Table+Column+Configurations)

Some background:

The datetime information in your database and the datatime datatypes in Ignition travel around the system as **objects** , and in Ignition, are timezoneless (UTC) **milliseconds** under the hood (`java.util.Date` objects, to be specific). They are only converted to strings for **display**.

Unfortunately, the javascript language used in browsers doesn't actually **have** this kind of object, so Ignition transmits the underlying UTC milliseconds to Perspective clients. Ignition's various Perspective UI components know how to **display** these as date/time strings when **told** to.

In the rare case when you need to convert to strings yourselves, there are hoops to jump through. See this topic for typical solutions:

> [@Ignition Perspective Page to show the client System date and time](https://forum.inductiveautomation.com/t/ignition-perspective-page-to-show-the-client-system-date-and-time/73265):
>
> Is it possible to display the client computer/system date and time on perspective web page? dateFormat(now(60000), "yyyy-MMM-dd HH:mm:ss a") showing the Gateway Server system date and time. Under Browse Tags-\> System -\> Client Tags are not available for Perspective sessions.

---

<div class="post-metadata">

**Author:** ![Vidar\_Hetlelid](https://avatars.discourse-cdn.com/v4/letter/v/dfb087/32.png) [@Vidar\_Hetlelid](https://forum.inductiveautomation.com/u/Vidar_Hetlelid)\
**Post date:** [October 23, 2023, 12:12am UTC](https://forum.inductiveautomation.com/t/how-to-format-date-inside-a-table/80825/3 "2023-10-23T00:12:51Z")

</div>

Thank you so much, works great! And thanks for the background info 🙂

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/2/12a1133b3c0d597dba2533bc73b7863228237424.png)