ScriptError: Invalid Argument Time Zone. Should be of type: String when running reports

[Larry Kokoszka]

Thank you so much for this awesome tool. I love being able to pull data into Excel automatically to manipulate it from the spreadsheet.


I set up a report in a pretty basic way but am getting an error when I run the report.


Error Message: ScriptError: Invalid Argument Time Zone. Should be of type: String


This is what my report looks like: https://i.imgur.com/C295hbx.png


Start Date is hard coded and end date is =today()-1


Other than that it's a pretty standard report. Does anyone know where the time zone error might be coming from or how I might debug the issue? There were no results in this forum when I searched on that error. 

Thanks for any assistance!

[Philip Walton]

What is set under "File" > "Spreadsheet settings" > "Time zone"?

Try changing to something else and changing it back, and let me know if that fixes thing.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/c149fe18-f17d-4fab-8261-4c1ccb5a65a2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[athl...@stpatbryan.org]

I was having the same issue as Larry and your solution did the trick. Thank you!

[pzic...@advancelocal.net]

@Philip Walton: That worked for me, too! Thanks!

[hoang tran duc]

I have the same problem

[Ewelina Walkenbach]

Nice trick! It worked for me too. Thanks

[Ankit Jain]

Hi, this solution is not working for me. Can you please please help?

On Friday, March 31, 2017 at 11:50:33 PM UTC+5:30 Philip Walton wrote:

What is set under "File" > "Spreadsheet settings" > "Time zone"?

Try changing to something else and changing it back, and let me know if that fixes thing.

On Fri, Mar 31, 2017 at 9:18 AM, Larry Kokoszka <larryk...@gmail.com> wrote:

Thank you so much for this awesome tool. I love being able to pull data into Excel automatically to manipulate it from the spreadsheet.


I set up a report in a pretty basic way but am getting an error when I run the report.


Error Message: ScriptError: Invalid Argument Time Zone. Should be of type: String


This is what my report looks like: https://i.imgur.com/C295hbx.png


Start Date is hard coded and end date is =today()-1


Other than that it's a pretty standard report. Does anyone know where the time zone error might be coming from or how I might debug the issue? There were no results in this forum when I searched on that error. 

Thanks for any assistance!

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.

[디안트보르트]

How about use just [yesterday] instead of [today()-1]
Think it's gonna work.

2022년 2월 27일 일요일 오전 12시 34분 52초 UTC+9에 Ankit Jain님이 작성: