ConvertToLocalTime not working in Japan env.

Thu, 04 Sep 2014 16:00:52 GMT

I've been using ConvertToLocalTime with much success for over a year; e.g.

Load *,

ConvertToLocalTime( gmt_date_time, 'Eastern') as [Eastern Date];

Recently we started deploying our documents to a QV server in Japan. One thing we've seen is that the ConvertToLocalTime function doesn't seem to work in that environment. Instead of an adjusted timestamp, the above expression returns 'Eastern?'. I tried converting the locale 'Eastern' to it's Japanese equivalent string representation (using Google Translate: 東の ) and now I get '東の?' back.

Any ideas what I need to do to get this to work?

Thanks.

Steve

Re: ConvertToLocalTime not working in Japan env.

jerem1234 — Thu, 04 Sep 2014 16:11:56 GMT

Maybe try:

ConvertToLocalTime( gmt_date_time, 'GMT-05:00') as [Eastern Date]

Hope this helps!

topic Re: ConvertToLocalTime not working in Japan env. in QlikView

ConvertToLocalTime not working in Japan env.

Re: ConvertToLocalTime not working in Japan env.