Perspective Table - Date Format

Hello,

I’m trying to format the date in a table column, and I’m getting mixed results per the screenshot. Any ideas as to why it isn’t consistently parsing the output data from my named query?

1 Like

Without seeing the data being returned and the render property of the column I’m not able to help much. Could someone provide those two pieces of information? Is the date being returned from the query stored as a date or as a string in the table? Are there any transforms acting on the data before it is supplied to the Table? What version of Perspective/Ignition are you using?

I’m using a Nightly build of 8.1.2 and I’m not seeing this, but it’s impossible to tell if that’s because it’s been fixed or if my data is just in a format which the Table is expecting when perhaps yours is not.