topic Re: Formula for converting IST to Malaysian timing ?? in QlikView

Formula for converting IST to Malaysian timing ??

nikhilgarg — Thu, 04 Dec 2014 06:31:32 GMT

HEy,

I have a column of date in IST:

04-11-2013 21:53:00

I want to convert it to malaysian timing in excel sheet . I could not find it on net.

Pls help me.

Thanks

sushil353 — Thu, 04 Dec 2014 07:09:07 GMT

Hi,

Use function ConverToLocalTime(Timedim,'UTC')

HTH,

Sushil

arulsettu — Thu, 04 Dec 2014 07:11:16 GMT

try this

=ConvertToLocalTime('04-11-2013 21:53:00','Kuala Lumpur')

nikhilgarg — Thu, 04 Dec 2014 07:26:06 GMT

Hey,

Your above formula is giving wrong timing according to malaysia

sujeetsingh — Thu, 04 Dec 2014 07:28:28 GMT

ConvertToLocalTime('04-11-2013 21:53:00','UTC+08:00')

this should work

nikhilgarg — Thu, 04 Dec 2014 07:31:10 GMT

Hey,

If my IST timimg now is 13:00 then in Malaysia , it is : 3:30 pm.

Then how does above formula right for malaysia ??

sujeetsingh — Thu, 04 Dec 2014 08:17:32 GMT

Do one thing then

Convert to UTC00:00 then to utc+08:00

nikhilgarg — Thu, 04 Dec 2014 09:26:12 GMT

Hey,

I tried in this way but no value shown in D@ column:

Time([Event Start Time], 'hh:mm:ss') as StartTime,

ConvertToLocalTime('StartTime','UTC+00:00')as d1,

ConvertToLocalTime('d1','UTC+08:00')as d2,