Changing Time Zone on Excel Reports?

Report · Aug 12, 2019

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!

Report · Aug 12, 2019

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

Report · Aug 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!