String Formatting

[wagsacap]

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 ?

[Vengatesh]

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')

[tresB]

May be like:

TimeStamp(Date#(PurgeChar('2019-03-26T19:00:00Z', 'ZT'), 'YYYY-MM-DDhh:mm:ss')) as [Time Stamp]