topic Re: ConvertToLocalTime() giving 1hr variance as compared to actual time in Insight Advisor

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

mindy6 — Mon, 26 Jun 2023 12:29:29 GMT

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?

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

Zapparoli — Mon, 26 Jun 2023 12:50:46 GMT

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

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

Josef_Gustafson — Tue, 27 Jun 2023 08:05:05 GMT

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.