cancel
Showing results for 
Search instead for 
Did you mean: 

GMT to Local time (EST/CST/PST)

former_member374954
Participant
0 Kudos

Hi Guys,

I am working on a report and need help for converting GMT to local time zones, all three (EST/CST/PST). Data is stored in GMT in TERADATA and User wants to see converted values depending on which Location they are opening the report. There are three locations and each uses one Time Zone (STL1-EST, STL2-CST, STL3-PST).

Any suggestions to achieve this scenario?

Regards

Prashant

Accepted Solutions (0)

Answers (1)

Answers (1)

CarlyThomas
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Prashant,


I don't believe this is currently not possible for WebI if the times are being pulled from the database based on user's locale.

Here's a KBA on it:

http://service.sap.com/sap/support/notes/1805140

I'd recommend creating an Enhancement Request to have this functionality added in SAP Ideas Place (http://ideas.sap.com).

The other option I can think of is creating separate reports for each timezone and writing a formula to convert the times.

I hope that helps,

Carly