You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Obtain user's timezone from preferences

edited Apr 29, 2019 10:49AM in Reporting and Analytics for ERP 4 comments

Summary

Obtain user's timezone from preferences for BIP report

Content

 We have a BIP report which needs to display datetime values based on user's location (timezone). We can use the function FROM_TZ to convert the values from DBTIMEZONE to a desired timezone, but how do we obtain the user's timezone from their BI preferences? Is there a table or function that we could use to do this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!