topic Re: function ConvertToLocalTime is not working proper on Win 7 in Archived Groups

function ConvertToLocalTime is not working proper on Win 7

rbecher — Wed, 23 Jul 2025 14:48:52 GMT

It seems that the function ConvertToLocalTime( ) is not working proper on Win 7 if the placce parameter has a 'GMT+01:00' value.

Fortunately it's still working with 'Berlin' (see attached example).

- Ralf

Miguel_Angel_Baeyens — Thu, 16 Jun 2011 11:39:51 GMT

Hello Ralf,

Use instead

ConvertToLocalTime(Timestamp, 'UTC+02:00')

I know that "GMT" -and not "UTC"- is in the Reference Manual but the above works for me.

Hope that helps.

BI Consultant

EDIT: Win 7 SP1 x64, QlikView 10.00.8935.7 SR2 x64

rbecher — Thu, 16 Jun 2011 12:14:56 GMT

Hi Miguel,

thanks for your hint. Wonder why this is OS related. GMT is working on XP...

- Ralf

Miguel_Angel_Baeyens — Thu, 16 Jun 2011 14:35:39 GMT

Hello Ralf,

That has changed in Windows 7. Further documentation from Microsoft here and here. Run a shell prompt and use

tzutil.exe /l

And you see all your OS timezones based on UTC instead of GMT. A note to QlikTech Support guys is worth so they can correct the documentation.

Regards,

BI Consultant