When trying to format one of the Date fields, the format does not display as expected.
When selecting the Field Override, Standard Options - Unit, selecting DateTime US, column such as "First Notified", "Last Notified" and "Last Cleared" displays the value "NaN" (Not a Number) instead of the regular time format (YYYY-MM-DD hh:mm:ss).
There is no format option for the time display to YYYY-MM-DD hh:mm:ss display.
2.3.1.
When data is inserted into the database, it is inserted as the field type TEXT instead of field type NUMBER.
To workaround the issue, when creating the query, add the "Transform Data" parameter for the "Date Fields" to make them "Number".
Once that is done, add field override for "Standard Unit of DateTime Local".
The date will display correctly.