Skip to main content
Inspiring
August 12, 2019
Pregunta

Changing Time Zone on Excel Reports?

  • August 12, 2019
  • 1 respuesta
  • 773 visualizaciones

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!

Este tema ha sido cerrado para respuestas.

1 respuesta

zweigle@clarix.com
Participating Frequently
August 12, 2019

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

Walter Zweigle - Sales Account Manager | Clarix Technologies Inc. | 585-899-5300 x156 | zweigle@clarix.comAdobe Connect | Adobe Learning Manager | Adobe Acrobat Sign
Inspiring
August 15, 2019

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!