SQL Date Range Problem with Between

Hello,

I am sure someone has hit this bottleneck before with the BETWEEN operator.
My search online was not successful.

Objective is to get a total for a date range within different months/years.

This statement works fine, for the same month.

Select sum(SALES) 
       From Daysales WHERE CPY  = 22 and STR = 1234 AND
                   CALY BETWEEN 2009  And 2009 AND
                   CALM BETWEEN 07 And 07 AND  : This is in July
                   CALD  BETWEEN 14 And 31;  

This statement Returns zero if the CALD is less than 14. But I haven't verified if value is correct even if the CALD > 14.

Select sum(SALES) 
       From Daysales WHERE CPY  = 22 and STR = 1234 AND
                   CALY BETWEEN 2009  And 2009 AND
                   CALM BETWEEN 07 And 08 AND  : This is from July thr Aug 10
                   CALD  BETWEEN 14 And 10;

Any help is greatly appreciated.