cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert Data Time from One Time Zone to another Zone...?

Former Member
0 Kudos

Hi Everyone,

I am creating one report in WEBI where i need to change the date time from one time zone to another time zone.

for ex: singapore(GMT+8) to thailand(GMT+7).

please let me help in this situation. its very urgent.

kind regards,

Santosh kumar.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I believe I misunderstood your issue so say for example you have 1 Hr difference between Singapore Time and so we will take an hour part from a day which is 1/24.

Now we will just use that in our code to display the time and it will be like

=Substr(( (FormatDate(RelativeDate(CurrentDate();-(1/24));"MM/dd/yyyy hh:m:ss")))

;(Pos( (FormatDate(RelativeDate(CurrentDate();-(1/24));"MM/dd/yyyy hh:m:ss"));":")-2);20)

So you see I have substracted 1 hr from current date and formatted that Date to extract only Hour Min and Second.

Similarly whatever is the Timezone difference we will have its part from 24 hrs.

Let me know if this helps

Regards

Niraj

Former Member
0 Kudos

Hello Santosh,

Open your Webi Report Cliclk on Properties-->Application as shown in screen shot and select the Locale that you want. This should work for you.

Regards

Niraj