# Time date in perspective **URL:** \ **Category:** Ignition\ **Created:** [October 19, 2020, 6:38pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815 "2020-10-19T18:38:43Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 6:38pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/1 "2020-10-19T18:38:43Z")
I am using Ignition 8.0.13. I am having a problem getting a time/date displayed on a table. I am logging the time when a sensor detects an object on a conveyor. The format is correct in the Database and in the Dataset Editor but is incorrect in the Designer and in a session. Something very simple that I can not find. I hope. ![DB](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/a/bad6ef1d8b9ff37e6d422709ed56bfa36f801beb.png) ![Dataset](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/0/a0b69a682b679c6accd6217851fef7d174edfffc.png) ![Designer](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b71588278aac000dc770a487aed2ae11e3dc529.png) ![Session](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9ca37138917c4706ef34dd054125bb18d1fd6beb.png) ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [October 19, 2020, 6:51pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/2 "2020-10-19T18:51:32Z")
Are you specifying the columns in the table? If you specify the columns then the table will recognize it is a date and should do the conversion. ---
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 6:54pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/3 "2020-10-19T18:54:59Z")
I simply bound the data to the table. Looking at it with the dataset Editor shows the correct data type. Is there a table property I can edit to force the data into a date format? ---
**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:** [October 19, 2020, 6:56pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/4 "2020-10-19T18:56:44Z")
> [@bschroeder](#): > > If you specify the columns then the table will recognize it is a date Actually, if render is set to "auto", then the value will be interpreted as a numeric value, and so will continue to display as a number. @bschroeder is on the right path, however. What you should do is make sure that you properly specify that you want that column to be rendered as a date. Your config should look like this for each of the columns displaying a date: ![Screen Shot 2020-10-19 at 11.55.59AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/f/efc7436d02c5df45e0818b7e2596f4467b435945.png) Make sure that the column specifies the column name as the `field` value, and make sure you set the `render` value to be "date". From there, you can manipulate the date format by modifying the `dateFormat` property of the appropriate column. ---
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 7:10pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/5 "2020-10-19T19:10:49Z")
Karma is not good to me today. I changed all three items and still get the same result. ![Property](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/9/2930aaacc3033ca18982fa727397f618c1ae234d.png) ![Designer2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/8/08eb4d4048efa5c74b2ee62f8f37d482b3b5e94e.png) ---
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 7:13pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/6 "2020-10-19T19:13:43Z")
Missed one. ![Designer3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9c086f6d704680bb82dd8c21ba854e74f6531b8c.png) ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [October 19, 2020, 7:28pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/7 "2020-10-19T19:28:30Z")
The field property must be set properly or it will not work, at least that has been my experience (just tried as well). But, on 8.0.16 setting to render to date does work. Edit, for me, it doesn’t matter if render is date or auto, it will show the correct date format ---
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 7:44pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/8 "2020-10-19T19:44:33Z")
The Field property is the column name from the database. Correct? I must support some projects using 8.0.13. IT will not let me put a VM on this computer. At least not yet. ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [October 19, 2020, 7:47pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/9 "2020-10-19T19:47:07Z")
Yep. For the table on the binding for props.data what is the Return Format set for? ---
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 7:54pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/10 "2020-10-19T19:54:05Z")
dataset ---
**Author:** ![thomas.stevic](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Post date:** [October 19, 2020, 7:57pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/11 "2020-10-19T19:57:54Z")
I found it!!! I had a space before the field property. Thank you all. ---
**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\ **Post date:** [March 23, 2021, 3:34pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/12 "2021-03-23T15:34:41Z")
it doesn`t work in 8.0.16 ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [March 23, 2021, 3:57pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/13 "2021-03-23T15:57:29Z")
What type of data is your table.props.data set for? Have you explicitly set the column field and the render for the column you want as a date? ---
**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:** [March 23, 2021, 4:06pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/14 "2021-03-23T16:06:38Z")
> [@Andrii.Randiuk](#): > > it doesn`t work in 8.0.16 This isn't enough information for me to help you get it working. If you're able to provide some insight into your data shape and a screenshot of the column configuration, I can probably help you get it working. ---
**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\ **Post date:** [March 23, 2021, 4:23pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/16 "2021-03-23T16:23:25Z")
is it enought? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/f/1f97573c6b85dffdf335e50deafd0195f4729d15.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:** [March 23, 2021, 4:24pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/17 "2021-03-23T16:24:23Z")
“Time Stamp” is not the name of any column in your table. Change `field` to have a value of “ConfirmTimestamp”. ---
**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\ **Post date:** [March 23, 2021, 4:27pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/18 "2021-03-23T16:27:24Z")
I understand , when I write in field name column, then i have time) thanks! ---
**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\ **Post date:** [March 23, 2021, 4:28pm UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/19 "2021-03-23T16:28:31Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/a/5a76e1084e6a66738bed987e098bbc7d6089e940.png) ---
**Author:** ![Sangeeta\_Gorai](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@Sangeeta\_Gorai](https://forum.inductiveautomation.com/u/Sangeeta_Gorai)\ **Post date:** [April 1, 2023, 11:26am UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/20 "2023-04-01T11:26:29Z")
This method is not working ---
**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:** [April 1, 2023, 11:56am UTC](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815/21 "2023-04-01T11:56:22Z")
You would need to supply a **lot** more information before anyone could help you. [Next page](https://forum.inductiveautomation.com/t/time-date-in-perspective/39815.md?page=2)