Report Builder file scheduling - Time Zone for Processing Excel

Saurabh_Kumar1 31-10-2017

Hello Everyone,

    We have used formula in excel to roll the end date for the monthly scheduled report. We are reporting Adobe metrics on month to date, year to date etc. However, we started running in to issues where the Excel time zone on Adobe's servers were sometimes on a different "today" than our report suite's timezone's "today." Two questions -

1) Do we know the specific time zone used for processing excel dates (using formula "=EOMONTH(TODAY(),-1)") by Adobe

2) Any suggestion for the fix.

Thanks!

Regards,

Saurabh Kumar.

Accepted Solutions (1)

Accepted Solutions (1)

Gigazelle
Employee
02-11-2017

Hi Saurabh, I think the following KB article will fully answer your question: Report Builder and the TODAY() or DATEVALUE() function

To resolve your issue, you'll want to use the preset dates in the Report Builder wizard, as those use the report suite time zone and not the time of the server that's processing your workbook.

Answers (0)