Some five digit number are in date format

Hi community,

I have in some fileds of the table 5 digit numbers. When I use pivot action, it converts them from number to date.
Hoes anyone have a solution? Quite annoying.

Hi Andras,

See this answer: Issue with parsing json and formatting the result - #2 by andrew.rybka

1 Like