topic Re: convert in date & time format in QlikView

convert in date & time format

userid128223 — Sat, 20 May 2017 05:20:42 GMT

Hi Everyone

I have following call:

LET vDate= Peek('StartD',$(i),TableA)

vDate = 04/06/2017 13:27:15

How can i convert it into:

vDate=2017-04-06T13:27:150Z

Anil_Babu_Samineni — Sat, 20 May 2017 05:23:03 GMT

What is the 0Z ??

sunny_talwar — Sat, 20 May 2017 11:54:03 GMT

May be this

LET vDate = Date(Date#(Peek('StartD',$(i),TableA), 'MM/DD/YYYY h:mm:ss'), 'MM/DD/YYYYT h:mm:ss0Z');

LET vDate = Text(Date(Date#(Peek('StartD',$(i),TableA), 'MM/DD/YYYY h:mm:ss'), 'MM/DD/YYYYT h:mm:ss0Z'));

antoniotiman — Sat, 20 May 2017 13:27:48 GMT

Hi,

I assume Your Timestamp Format is

SET TimestampFormat='MM/DD/YYYY hh:mm:ss[.fff]';

=Replace(Timestamp(vDate,'YYYY-MM-DD_hh:mm:ss0Z'),'_','T') -> 2017-04-06T13:27:150Z

Regards,

Antonio

userid128223 — Sat, 20 May 2017 14:03:47 GMT

Hi Sunny

T in middle is not showing up & it is leaving spaces in between.

sunny_talwar — Sat, 20 May 2017 14:08:45 GMT

Don't need space

LET vDate = =Replace(Date(Date#(Peek('StartD',$(i),TableA), 'MM/DD/YYYY h:mm:ss'), 'MM/DD/YYYY@ h:mm:ss0Z'), '@', 'T');

Tried it with static date

=Replace(Date(Date#('04/06/2017 13:27:15', 'MM/DD/YYYY h:mm:ss'), 'MM/DD/YYYY@ h:mm:ss0Z'), '@', 'T')