Reading the Qlik Sense Script Logs

[IuliaM]

Hello Everyone,

I am trying to read into a Qlik Sense application the log files generated by other applications and I have difficulties to interpret the date time format which looks like this: 20220520T092936.038+0200  or 20220520T092936.058+0200 0024 .

does anyone know a formula that I can use to transform this into a normal date time format?

Cheers

Iulia

[rubenmarin]

Hi, that format is YYYYMMDDThhmmss.fff with 2 hours added to the UTC, you can use timestamp() to convert to an easy readable timestamp

=timestamp('20220520T092936.038+0200')-> 20/05/2022 07:29:36

The output format depends of the TimestampFormat variable set at the start of script.