Why does =if(c7<b2<d7,1,0) not work? A between number sentence....

All cells of course have numbers. Lets say b2 is 9; c7 is 0 and d7 is 10. Im asking it to give me a 1 if b2 is between the other 2 cell values and a 0 if false. All I can figure is that "between" is expressed in some other way. I'm sure this is incredibly easy and I'm very frustrated that I'm unable to make it work.

Initially I was trying to get a true or false on whether one date was inbetween two other dates.... and when that wouldn't worked just tried straight numbers. Can't even get that to work.

Any help would be greatly appreciated!

Thanks, Karin