Hi JE,

Thanks to you also for all the efforts. Will try to work on it once I get
some time.

Mangesh



"JE McGimpsey" wrote in message
...
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