topic Re: Convert date time and timezone in QlikView

Convert date time and timezone

userid128223 — Wed, 13 Dec 2017 21:22:47 GMT

How do you convert below to date & time separately.

2017-11-20T01:30:00-05:00

Output:

Date: 2017-11-20

Time: 01:30

Thanks

Anil_Babu_Samineni — Thu, 14 Dec 2017 01:19:18 GMT

I will go with this?

Date = Left('2017-11-20T01:30:00-05:00' ,10)

Time = Left(SubField('2017-11-20T01:30:00-05:00' ,'T', -1), 5)

Anil_Babu_Samineni — Thu, 14 Dec 2017 01:25:35 GMT

Or, Simplest way to achieve

=Date(Timestamp(ConvertToLocalTime('2017-11-20T01:30:00-05:00')), 'YYYY-MM-DD')

its_anandrjs — Thu, 14 Dec 2017 04:54:00 GMT

For Date do this way

=Date(Left('2017-11-20T01:30:00-05:00',10))

For Time do this way

=Time( Mid('2017-11-20T01:30:00-05:00',12,5))