# Perspective Table - Date Format **URL:** \ **Category:** Ignition\ **Created:** [June 25, 2019, 1:57pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-format/26081 "2019-06-25T13:57:48Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![tim.schultz](https://avatars.discourse-cdn.com/v4/letter/t/71e660/32.png) [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Post date:** [June 25, 2019, 1:57pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-format/26081/1 "2019-06-25T13:57:48Z")
Hello, I’m trying to format the date in a table column, and I’m getting mixed results per the screenshot. Any ideas as to why it isn’t consistently parsing the output data from my named query? ![Perspective%20Date%20Format%20ISsue](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/38c9d6ed221b66b0d0adec6d7050bd54afcb6f62.png) ---
**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:** [December 17, 2020, 11:56am UTC](https://forum.inductiveautomation.com/t/perspective-table-date-format/26081/3 "2020-12-17T11:56:16Z")
Without seeing the data being returned and the `render` property of the column I’m not able to help much. Could someone provide those two pieces of information? Is the date being returned from the query stored as a date or as a string in the table? Are there any transforms acting on the data before it is supplied to the Table? What version of Perspective/Ignition are you using? I’m using a Nightly build of 8.1.2 and I’m not seeing this, but it’s impossible to tell if that’s because it’s been fixed or if my data is just in a format which the Table is expecting when perhaps yours is not. ---
**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:** [April 12, 2024, 5:27pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-format/26081/4 "2024-04-12T17:27:16Z")
2 posts were split to a new topic: [Perspective Table Date Column Filtering](https://forum.inductiveautomation.com/t/perspective-table-date-column-filtering/88749)