topic Re: ConvertToLocalTime in QlikView

ConvertToLocalTime

Thu, 17 Apr 2014 20:56:36 GMT

I am trying to do convert GMT times to local for different time zones. This is what works if I had only one time zone to convert:

=Hour(ConvertToLocalTime(Program_View_Start_Time, 'GMT-05:00'))

How do I define a variable to use instead of 05:00 ?

Thank you in advance

Re: ConvertToLocalTime

MK_QSL — Thu, 17 Apr 2014 21:39:55 GMT

Create Two Variables

vVar1

This variable will take time input as hh:mm or -hh:mm format ... i.e. -02:00 or 03:00

vVar2

=IF(vVar1 < 0, 'GMT'&'-'&TIME(Right(vVar1,5),'hh:mm'),'GMT'&'+'&TIME(vVar1,'hh:mm'))

Now use below

=ConvertToLocalTime(NOW(),vVar2)

Re: ConvertToLocalTime

Thu, 17 Apr 2014 21:49:50 GMT

Thank you so much. It is working for my GMT-3, GMT-4, GMT-5 and GMT-6 conversions. It needs formatting changes for 2 digit subtractions (i.e GMT-10) .

Re: ConvertToLocalTime

Thu, 17 Apr 2014 21:50:29 GMT

This works perfectly as well. Thank you so much Manish

Re: ConvertToLocalTime

MK_QSL — Thu, 17 Apr 2014 21:52:43 GMT

Just Guessing, is this working for GMT-05:00 or any negative value also?

Re: ConvertToLocalTime

MK_QSL — Thu, 17 Apr 2014 21:54:08 GMT

Just Guessing, is this working for GMT-05:00 or any negative value also?

Re: ConvertToLocalTime

Thu, 17 Apr 2014 21:57:37 GMT

Azmir, My solution is not perfect, sorry. It will not give possibility to have for example GMT+10:00. Turn off correct answer from my response, please.

Re: ConvertToLocalTime

MK_QSL — Fri, 18 Apr 2014 06:58:03 GMT

If my solution is working, can you close the thread by selecting correct answer?