Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jerem1234
Specialist II
Specialist II

Maybe try:

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


Hope this helps!

View solution in original post

1 Reply
jerem1234
Specialist II
Specialist II

Maybe try:

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


Hope this helps!

View solution in original post