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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mindy6
Contributor
Contributor

ConvertToLocalTime() giving 1hr variance as compared to actual time

Hi, If reloadtime() returns Europe time, for example 6am. Then, I try to ConvertToLocalTime(ReloadTime(), 'New Delhi') it should add 4.5 hours right and return 10:30 am? But it returns 11.30 am

What's the mistake?

Labels (1)
1 Solution

Accepted Solutions
Zapparoli
Creator II
Creator II

Hi Mindy,

New Delhi time is GMT +5:30 hours, So it will get your reload time and add +5:30 hours to it.

As far as I understand it's working correct.

-Zapparoli

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics

View solution in original post

2 Replies
Zapparoli
Creator II
Creator II

Hi Mindy,

New Delhi time is GMT +5:30 hours, So it will get your reload time and add +5:30 hours to it.

As far as I understand it's working correct.

-Zapparoli

Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics

Josef_Gustafson
Former Employee
Former Employee

Hi @mindy6,

As mentioned by Zapparoli, New Delhi is GMT +5:30, meaning that it works as expected. Also, keep in mind that there are different timezones in Europe, such as CEST, GMT+1, GMT+3 and EEST and which might affect your results.