LocalTime Error ! - Qlik Community

Report Inappropriate Content · ‎2013-04-19

When I use LocalTime(), it gives the current time and date of my system. My time zone is GMT+05:30 as per TimeZone() function.

When I used

ConvertoLocalTime(LocalTime(),'GMT+05:30')

I get a different time than my current time.

kaushiknsolanki · ‎2013-04-19

Hi,

What it does is, it adds the time difference in the date you pass.

So in your case it must be showing the +5:30 hr more than your local time.

Try this.

=ConvertToLocalTime(UTC(), 'GMT+05:30')

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-04-19

It Worked.

kaushiknsolanki · ‎2013-04-19

Hi,

Kindly close the post, by marking this as Correct Answer

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!