ConvertToLocalTime not working in Japan env.

[#1]

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

[jerem1234 · Accepted solution]

Maybe try:

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

Hope this helps!