function ConvertToLocalTime is not working proper on Win 7

[rbecher]

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]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

EDIT: Win 7 SP1 x64, QlikView 10.00.8935.7 SR2 x64

[rbecher]

Hi Miguel,

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

- Ralf

[Miguel_Angel_Baeyens]

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,

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica