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…

Question 1: Name the SQL field in each of the columns.0.field properties. e.g. columns.0.field : Timestamp. Then the rest of the properties will work. columns.0.render : date columns.0.dateFormat: YYYY-MM-DD Question 2: I have multiple SQL table being generated on one sheet. Perspective do…

There is just one table that it will download the the above code.. do I need to add the other table data names into this part to get separate tabs in the excel sheet? P.S. I don't code.. i dabble as best and can reuse things I already have. I'm Learning :slight_smile: [image] Ben_Blaschuk: da…

I am going to add to this for us that are not coders. There is a Property on the left that is your column properties. see picture. When you click the "+" it will look like your other columns have disappeared. Have no fear, they are there. Keep pressing the "+" until all of your other columns ar…

I solved question 2... i needed to create the "data" datasets and then add them into the download like shown below. :slight_smile: YAY ME!!... lol startdate = self.getSibling("DateTimeInput").props.value startdatestr = str(startdate) enddate = self.getSibling("DateTimeInput_0").props.value endda…

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.