Question:
Default:
Magento store all times in UTC.
So the time on the report isn't correctly. if you are in other place.
Solution:
# db-time to local time
echo Mage :: getModel ( 'core/date' )-> date ( null , strtotime ( '2010-05-11 15:00:00' )); // '2010-05-11 17:00:00'
# local time to db-time
echo Mage :: getModel ( 'core/date' )-> gmtDate ( null , strtotime ( '2010-05-11 17:00:00' )); // 2010-05-11 15:00:00