Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rbecher
MVP
MVP

function ConvertToLocalTime is not working proper on Win 7

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

Astrato.io Head of R&D
Labels (2)
3 Replies
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
MVP
MVP
Author

Hi Miguel,

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

- Ralf

Astrato.io Head of R&D
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