Hello All, I have 2 questions. There is an odd Date/Time Stamp that is being reported out into Perspective table from SQL. see picture below. When I transfer the date to a .xlsx file, it goes back to a normal format. Just in Perspective it's weird. How do I fix it. [image] As the picture…

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. [image] Perspective table displaying unix epoch date but not in dataset? Ignition Using SQL Server 2019 and Perspective 8.1.10. I have a name…

2 Things: Odd Date/Time value and multiple tables into 1 excel sheet

Ignition

Steve_Laubach February 6, 2024, 2:09pm 2

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.

1 Like