Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ag732312
New Contributor II

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

Life is so rich, and we need to respect to the life !!!
ag732312
New Contributor II

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.

Community Browser