Report Builder file scheduling - Time Zone for Processing Excel | Community
Skip to main content
S
Saurabh_Kumar1
Level 5
November 1, 2017
Solved

Report Builder file scheduling - Time Zone for Processing Excel

  • November 1, 2017
  • 1 reply
  • 1710 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Gigazelle

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.

1 reply

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
November 2, 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.

    Terms & ConditionsAccessibility statement

    Loading footer...