Between 2 Dates Problem

Hey all you all helped me with a formula for Between 2 dates. However this formula is removing the last day of that date range. Here is the Formula:

=SUMPRODUCT(--('Transaction DB'!$J:$J>=DATE('Set Date'!$D$2,'Set Date'!$B$2,'Set Date'!$C$2)),--('Transaction DB'!$J:$J<=DATE('Set Date'!$D$4,'Set Date'!$B$4,'Set Date'!$C$4)),--('Transaction DB'!$D:$D=B41),'Transaction DB'!$E:$E)

It will not work for a single day either. For instance

From: 01/01/2009 To: 01/01/2009 = Rusults in 0 Returned Records.

From 01/01/2009 To: 03/31/2009 = Results is missing day 03/31/2009 Data.

Thanks and hope there is an easy fix for this.