Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
IuliaM
Contributor III
Contributor III

Reading the Qlik Sense Script Logs

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

 

Labels (1)
1 Reply
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.