Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.