Skip to main content
loganm87922310
Inspiring
Aug 12, 2019 7:55 PM UTC
Question

Changing Time Zone on Excel Reports?

Hello everyone!

Got a non-urgent question here that maybe someone can help me with.

When I export a report to Excel from dashboard, I notice that all of our time fields (like completion dates) are defaulted to UTC TimeZone. Now, I personally am located in Central Time (CST/CDT) or UTC-5:00 currently. So, all our dates and times are 5 hours in the future (or so it appears) due to the times being in UTC.

On our Prime settings, the timezone for the LMS is set to (UTC - 06:00) US/Central and my Adobe Profile is also set to the same. This is our Company's main timezone.

Is there a way to change the reports being exported into Excel to show times in our timezone? Or, is it always defaulting to UTC and we have to convert manually on the exported data?

Thanks again for any help here!

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

zweigle@clarix.com
zweigle@clarix.com
Participating Frequently
Aug 12, 2019 9:29 PM UTC

As far as I know this cannot be changed. Captivate Prime downloads time data and fields as stored (as UTC).

Translate
Walter Zweigle - Sales Account Manager | Clarix Technologies Inc. | 585-899-5300 x156 | zweigle@clarix.comAdobe Connect | Adobe Learning Manager | Adobe Acrobat Sign
loganm87922310Author
Inspiring
Aug 15, 2019 6:26 PM UTC

That's what I feared. I'll just use my Excel formulas to adjust the reports I provide. Will likely cause our managers to not use their dashboards as much if they pull reports and dates are not in our time.

Thanks!

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices