I have an issue with the Transaction report that is far from critical, but does cause me inconvenience from time to time. I have my store settings time set for Eastern US & Canada (GMT-5:00), however when I run a transaction report for a particular date range, the report seems to run on Pacific time zone (GMT-8:00). The orders are all stamped with the time of the order being GMT-5:00, but the report includes orders placed between midnight and 3:00 AM on the day AFTER the end-date-range, but not orders between midnight and 3:00 AM on the first day of the date range.
For example, if I run a transaction report for the date range of 3/25/12 to 3/25/12 (i.e. just for yesterday) the report will not include the order placed at 2:20 AM on 3/25, but will include the order placed at 1:45AM on 3/26.
Is there a way to get the date range to be based on the selected timezone for the store? Is there a setting I am missing?