BasicReportService always returns PST time
- Hi there,
I'm having the following very very frustrating problem.
I try to request a report (using Java and connecting to the sandbox) giving the start and end date for the period, explicitly making them in EST time. Then I also set the calendar object that is passed to the request as EST too. Here's the code:
java.util.Date startDate = df.parse("2010-01-18 00:00:00 GMT-5:00");
java.util.Date endDate = df.parse("2010-01-19 00:00:00 GMT-5:00");
In this case I get a report for days 17th and 18th instead of 18th and 19th with the following info in the XML: dateStart="2010-01-17-0800" dateEnd="2010-01-18-0800"
I realize that this is because in PST the requested times really are Jan 17th 10 pm and Jan 18th 10 pm and so I get the reports for Jan 17-18 12 am to 11:59:59 pm PST time.
How can I request the report to include the EST times instead?
Thanks in advance for any help. Maybe I'm missing something crucial here.