I'm an Access Programmer...

A co-worker asked why this doesn't work - it gives "0".

=SUMIF(C27:C38,"<01/04/2006 and 11/17/2005",D27:D38)

The...
"<01/04/2006 and 11/17/2005"...doesn't work

"<01/04/2006"...does work

TIA - Bob