Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to format 2019-03-26T19:00:00Z into a time format to find the duration differences between two values.
How can I do the same using Qlik Load Editor ?
Try this
Date(Date#(Left('2019-03-26T19:00:00Z',10)&' '&Left(Right('2019-03-26T19:00:00Z',9),8),'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')