This is unusual

[Si_the_geek]

Ah!! just realised it is a date-time field!!

when you don't specify a time it assumes midnight, so just set the parameters like this:

(B.datetime >= '04/20/2001' AND B.datetime < '04/22/2001')