Reading the Qlik Sense Script Logs

IuliaM — Wed, 06 Jul 2022 07:45:45 GMT

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

Re: Reading the Qlik Sense Script Logs

rubenmarin — Wed, 06 Jul 2022 10:30:13 GMT

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.

topic Reading the Qlik Sense Script Logs in App Development

Reading the Qlik Sense Script Logs

Re: Reading the Qlik Sense Script Logs