Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
New Contributor III

Convert to Local Time Issue?

Hi Experts,

I am trying to convert a Datetime field from a MS SQL DB on EST  to my current Timezone:

1. If I user LocalTime() Function it Shows my System has the time Zone two Hours ahead, If I user LocalTime('Central America') Shows my current time, this is the scenario I expect to happen.

2. But when I use the function ConvertToLocalTime(DB Date Time Field,'Central America') it shows the datetime like 8 hours ahead from when really happened, if Use the same function and instead of using 'Central America', I use 'UTC-02:00' I get an approximate Time, but I need to get the exact time based on my location.

Any thoughts?

Thanks in advanced

2 Replies

Re: Convert to Local Time Issue?

Probably UTC-02:00 is not the direction correct. Can you try Central Time Zone - Wikipedia

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor III

Re: Convert to Local Time Issue?

Thanks, I managed this issue by getting into the DB server and found the Time Zon se was set to UTC-4.

So UTC-2 or UTC-1 are the correct timezones considering the daylight savings.