# Prospective table component - Render-date-datetime **URL:** \ **Category:** Ignition\ **Tags:** perspective, ignition81\ **Created:** [March 17, 2025, 5:56am UTC](https://forum.inductiveautomation.com/t/prospective-table-component-render-date-datetime/103764 "2025-03-17T05:56:52Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![shubham\_Dhoke](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shubham_dhoke/32/85510_2.png) [@shubham\_Dhoke](https://forum.inductiveautomation.com/u/shubham_Dhoke)\ **Post date:** [March 17, 2025, 5:56am UTC](https://forum.inductiveautomation.com/t/prospective-table-component-render-date-datetime/103764/1 "2025-03-17T05:56:52Z")
Hey there everyone, This is Shubham. i am from india Regarding this post, I needed your help to resolve the issue of timestamps in the Prospective Table component (I have tried the online solution (set render to date, then set format to datetime), and it's not working). still the datetime column is in integer (it's showing numbers instead of date) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/c/6cbe810f3823e7b77f066a0bdce452b9d650c1fa.png) Please suggest something to correct this. Regards, shubham ---
**Author:** ![Abdelhak\_Sidi\_Ali\_Me](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/abdelhak_sidi_ali_me/32/72447_2.png) [@Abdelhak\_Sidi\_Ali\_Me](https://forum.inductiveautomation.com/u/Abdelhak_Sidi_Ali_Me)\ **Post date:** [March 17, 2025, 6:37am UTC](https://forum.inductiveautomation.com/t/prospective-table-component-render-date-datetime/103764/2 "2025-03-17T06:37:38Z")
Hi Shubham, Can you share more details? How are you getting your data exactly? What it its raw value? Can you show us your table props, especially the datetime part? ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [March 17, 2025, 9:02am UTC](https://forum.inductiveautomation.com/t/prospective-table-component-render-date-datetime/103764/3 "2025-03-17T09:02:55Z")
Make sure that you have set the `field` property in each column to match the name of the database column. It's case sensitive. In your case it would be something like, `columns.1.field : DateTime` Many of the column features don't work if you don't specify the `field` property correctly. Note that that DATETIME is a keyword in SQL so it's not a good name for a data column. Tips: - It's **Perspective** as in "a point of view", not Prospective as in "likely to happen at a future date". You can edit your post to fix the title and the post with the pencil icon below the post. - The Keep it Tidy section of the forum [FAQ - Inductive Automation Forum](https://forum.inductiveautomation.com/faq) requests that we don't add signatures to posts as your username is automatically displayed. If you want to introduce yourself or state your location, etc., then add that to your user profile. ---
**Author:** ![shubham\_Dhoke](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shubham_dhoke/32/85510_2.png) [@shubham\_Dhoke](https://forum.inductiveautomation.com/u/shubham_Dhoke)\ **Post date:** [March 17, 2025, 6:00pm UTC](https://forum.inductiveautomation.com/t/prospective-table-component-render-date-datetime/103764/4 "2025-03-17T18:00:55Z")
It worked "columns.1.field: DateTime." but to make it happen, i have to delete all the columns from the property editor and add one by one with propper naming same as column names in SQL ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [March 17, 2025, 6:26pm UTC](https://forum.inductiveautomation.com/t/prospective-table-component-render-date-datetime/103764/5 "2025-03-17T18:26:37Z")
It would have worked by naming them one by one. You can test this very quickly to see how it works by dropping a table component onto a view and setting the field property for each column in turn. - city - country - population You can also set each `columns.x.header.title` to read nicely without underscores or to be different words or language.