Table - Date formatting with json

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?

Json:
image

Dataset:
image

Thanks for any advice!

if you add items to the column prop you should be able to select a type and format for them

I do have columns set up in the columns prop but It just considers it a number not a date.

I tried to do system.date.fromMillis() on each of those but that ends up as a string.

Alright. I had to set the render to date like so:
image

Seems like with dataset it can decide what kind of column is it.

2 Likes

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:

You need to add the column name in the field property:

2 Likes

OMG..... THANK YOU @mpoulsen921...

You're awesome... Thank you so much!!

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.

1 Like