topic Re: LocalTime Error ! in QlikView

LocalTime Error !

Fri, 19 Apr 2013 10:18:37 GMT

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 — Fri, 19 Apr 2013 10:32:55 GMT

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

Fri, 19 Apr 2013 10:47:03 GMT

It Worked.

kaushiknsolanki — Fri, 19 Apr 2013 11:00:15 GMT

Hi,

Kindly close the post, by marking this as Correct Answer

Regards,

Kaushik Solanki