count error

Hi,

i am counting total number of hours for each order type weekiy.

in selection screen if i enter 1 month date range then it should calculate for 4weeks .

but my program is counting previous week value while calculating next week value.

for 1week if total hours are 12 for order type sm02

for next week if total hours are 10 for same order type sm02,

but my program is calculating as 22, similarly for same order type sm02 for 3week , if total hours are 5 , but my program is calculating as 27.

i would appreciate if anyone can give som logic for this.

thanks.

Raghu