Report Wizard changing dates

[DBerti]

I am using Sugar Professional Version 6.2.1 (Build 6405). I have a report that I built using the wizard and the report starts with a filter that uses a date range to filter data. Running the report for 12/1/11 - 12/31/11 gives me all of December's records PLUS a record for 1/1/12 - which is not part of the desired date range.

If I look at the WHERE clause in the query I cas see that the wizard added one day to my filter "End Date".

WHERE ((((pay_payments.date_entered>='2011-12-01 05:00:00' AND
pay_payments.date_entered<='2012-01-01 04:59:59')
) AND (pay_payments.payment_type <> 'ERROR'
)))
AND pay_payments.deleted=0

Can anybody help??

[jmertic]

I am using Sugar Professional Version 6.2.1 (Build 6405). I have a report that I built using the wizard and the report starts with a filter that uses a date range to filter data. Running the report for 12/1/11 - 12/31/11 gives me all of December's records PLUS a record for 1/1/12 - which is not part of the desired date range.

If I look at the WHERE clause in the query I cas see that the wizard added one day to my filter "End Date".

WHERE ((((pay_payments.date_entered>='2011-12-01 05:00:00' AND
pay_payments.date_entered<='2012-01-01 04:59:59')
) AND (pay_payments.payment_type <> 'ERROR'
)))
AND pay_payments.deleted=0

Can anybody help??

I'm guessing this is because of timezone differences, as the report datetimes are relative to the current user's timezone. Sounds like a possible bug to me.