Datetime in table column showing only int value after update to 8.0.14

I have problem with dateformatting. In previous version it worked normally but after update the value is not showing corectly

Value in SQL database is “date” datatype and Named query preview shows the right value.

In the UI when using table shows value incorrecty after update

Older version 8.0.9 works fine and the update was made to version 8.0.14

What could be possible reasons to this kind of behaviour?

I just ran into this recently as well. For that table, add a transform script:

return system.dataset.formatDates(value,“MM/dd/yyyy”)

1 Like