Perspective table date showing as number

I have a table I am showing in perspective and my time stamp is displaying as a number instead of a date. when I execute the name query is shows as a date. the column is listed as date format and showing the date in the dataset editor. but for some reason it is displaying as a number in the table.

configure the table columns in the columns property:

make sure you set up the field property, assign it the column name. This should fix it.

1 Like

Hi @Glen_Bennett,

under the table properties you can add columns definitions
image
in field set the name of the column you want to adapt
render set to date
set the correct date format.

You will need to do this for each column you want to visualize in your table

Regards

1 Like

That fixed it. Thanks!

to add onto that question, when the field is editable it pops up as a number. Any suggestions?

2 Likes