It was an error in my transcription. Try 11/30/2004. You get the same
result for both 2/28/2005 and 3/1/2005


In article ,
"Mangesh" wrote:

no problem. But I forgot to mention that the start date has to be less than
the end date. So in essence, your query should be

28-Feb-05 30-Nov-05 0 9 2
1-Mar-05 30-Nov-05 0 8 29


And it does give me proper results. The other way round would give some
negative results in month.

Mangesh



"JE McGimpsey" wrote in message
...
Hate to be continually sniping, but

A B C
1 11/30/2005 02/28/2005 0 3 1
2 11/30/2005 03/01/2005 0 3 1