Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
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!