Table DateTime working oddly with Named Query to Populate

In the imagine you will see how the dataset when you click the table diagram shows the date and time format as a non epoch value. You will also see the column is set to date and format is set properly. Although, it seems the named Query over-rides the column properties. The thing is the named query is converting the t_stamp from epoch time already, and for some reason the table when showing the named query converts it back to Epoch automatically. If I alter my query to show the t_stamp natively, the table still shows it as Epoch.

You need to set
columns.0.field : DateAndTime
so that it can apply the rest of your settings.

Setting the field property for every column is usually a good idea.

1 Like

Thanks a ton, that was a simple fix.