09-19-2023 09:06 AM
Hi,
We are trying to Display User Time when we export the report to excel on Excel Header. We tried using this code, but it is giving us the UTC Time.
09-20-2023 09:11 AM - edited 09-21-2023 02:45 PM
Since the XFBR code runs on the OneStream Server the server's Timezone will always be what is returned by TimeZone.CurrentTimeZone.
To use user TimeZones:
Store each user's three char time zone in one of the User account Text fields.
Then use the following code to look it up and use the TZ in your code above:
Dim strTimeZone as String = BRApi.Security.Authorization.GetUser(si, si.UserName).User.Text1;