Reporting - datetime formating

If you can't/won't change the query to do the casting to a true date time type (this is the best place to do it) you'll need to use a script data source to rewrite the column using a system.date function to parse the millis into a Java Date object.

You could use a script like this to do the column update:

1 Like