Loading ...
Sorry, an error occurred while loading the content.

BasicReportService always returns PST time

Expand Messages
  • stan.dragnev
    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
    Message 1 of 1 , Jan 21, 2010
    • 0 Attachment
      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");

              startCal.setTime(startDate);
              endCal.setTime(endDate);
              startCal.setTimeZone(TimeZone.getTimeZone("EST"));
              endCal.setTimeZone(TimeZone.getTimeZone("EST"));
              reportRequest.setStartDate(startCal);
              reportRequest.setEndDate(endCal);


      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.

      Stan
    Your message has been successfully submitted and would be delivered to recipients shortly.