# 2 Things: Odd Date/Time value and multiple tables into 1 excel sheet **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [February 6, 2024, 1:57pm UTC](https://forum.inductiveautomation.com/t/2-things-odd-date-time-value-and-multiple-tables-into-1-excel-sheet/85294 "2024-02-06T13:57:26Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\ **Post date:** [February 6, 2024, 2:09pm UTC](https://forum.inductiveautomation.com/t/2-things-odd-date-time-value-and-multiple-tables-into-1-excel-sheet/85294/2 "2024-02-06T14:09:21Z")
It's displaying the date in epoc time. You have to add a column definition to format it as a date. The field name has to match. > [@Perspective table displaying unix epoch date but not in dataset?](https://forum.inductiveautomation.com/t/perspective-table-displaying-unix-epoch-date-but-not-in-dataset/51588): > > Using SQL Server 2019 and Perspective 8.1.10. I have a named query that gets a datetime field from SQL Server. The datetime appears correct in the dataset. When I bind the dataset from my named query to the table, it comes in as unix epoch time however. I have not changed anything about the table formatting. It looks like this [image] I have set “render” for this column to “date” and the “dateFormat” to 'MM/DD/YYYY` but I am seeing these unix dates in the table still. Any idea what I am … --- _[View the full topic](https://forum.inductiveautomation.com/t/2-things-odd-date-time-value-and-multiple-tables-into-1-excel-sheet/85294)._