topic Re: Converting GMT to UTC-4 TimeStamp in QlikView

Converting GMT to UTC-4 TimeStamp

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

How can I convert the TimeStamp from GMT to UTC-4?

For example, I have the data field call "submitted date" which is GMT time. How can I convert it to local time UTC-4?

Also, if I want to get the month after converted the time. What will be the full command line looks like?

Thanks,

Becky

Re: Converting GMT to UTC-4 TimeStamp

iahamedabdullah — Tue, 14 Jun 2016 19:08:43 GMT

Hi Give a try,

1. To get UTC-4 use this Expression: Timestamp(submitted date-Time#(4,'hh'))

2. To get Month after conversion: Month(Timestamp(submitted date-Time#(4,'hh')))

Re: Converting GMT to UTC-4 TimeStamp

rbecher — Tue, 14 Jun 2016 19:20:38 GMT

Hi Yun,

you can use:

=ConvertToLocalTime(<YourTimeField>, 'GMT-04:00')

- Ralf

Re: Converting GMT to UTC-4 TimeStamp

Tue, 14 Jun 2016 20:20:31 GMT

Thanks Ralf.

Is your way suppose to use in script when load date, or use in expression?
I used the way in Expression. It shows error. Where should I change?

Re: Converting GMT to UTC-4 TimeStamp

Tue, 14 Jun 2016 20:26:56 GMT

Thanks! It works.

One more question, I can use this in expression right? Or I can use this both in script and expression?

Re: Converting GMT to UTC-4 TimeStamp

rbecher — Tue, 14 Jun 2016 20:36:12 GMT

‌Just use your fieldname. < > was a placeholder..

Btw, this is the only function taking care of daylight saving in target time zone. So, first example subtracting 4 hrs might not work in all situations.

Re: Converting GMT to UTC-4 TimeStamp

Wed, 15 Jun 2016 19:21:43 GMT

Thanks Ralf.

Is there a way that we can do with the daylight saving? Or we have to manually change the expression?

Re: Converting GMT to UTC-4 TimeStamp

rbecher — Thu, 16 Jun 2016 13:36:50 GMT

ConvertToLocalTime() does it automatically..

Re: Converting GMT to UTC-4 TimeStamp

Fri, 17 Jun 2016 18:42:03 GMT

Oh, thanks. I think I got confused from your previous comments. I thought the ConverToLocalTime() won't work for day light saving...

So for those country they don't have daylight saving, shall I use "Timestamp(Date - Time#(4,'hh'))"?

Re: Converting GMT to UTC-4 TimeStamp

rbecher — Sat, 18 Jun 2016 11:36:30 GMT

It should work also for places having no daylight savings but I'm not sure if the parameter is not a place but a GMT value. I think it would be probably better to use places (see help).