Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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
Support
Support

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.