Report Builder file scheduling - Time Zone for Processing Excel

Avatar

Avatar
Validate 1
Level 4
Saurabh_Kumar1
Level 4

Likes

26 likes

Total Posts

106 posts

Correct reply

44 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
Saurabh_Kumar1
Level 4

Likes

26 likes

Total Posts

106 posts

Correct reply

44 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Saurabh_Kumar1
Level 4

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)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
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)