Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Not applicable

ConvertToLocalTime not working in Japan env.

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

1 Solution

Accepted Solutions
Highlighted
Valued Contributor II

Re: ConvertToLocalTime not working in Japan env.

Maybe try:

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


Hope this helps!

View solution in original post

1 Reply
Highlighted
Valued Contributor II

Re: ConvertToLocalTime not working in Japan env.

Maybe try:

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


Hope this helps!

View solution in original post