Hi,
I am working on a overview table and I ran into a problem.
On data property I have a query binding that returns some data including dates.
If I select “dataset” as a return format. Everything works just fine. I can format the date.
If I select “json” as a return format then the dates come in as timestamp (I guess, see the picture) and I cannot format them.
I would like to use json as a return format because it makes it easier for me to color the background based on some conditions. Can I make it work with json too?
I am having issues formatting date in the table.. DATE is the only column in the table and here's what I have in Named Query Results, Table Results and Column settings in property editor of the table... Appreciate if I can get any help here:
Yes, for many of the table column properties to work the field property has to be set to an exact match of the column name. If things don't work as expected it's worth checking this.