Checking if date is inside date range

Hy list,

I would like to check if date is inside a given date range.

For instance if date range is

datestart column: 10/10/2005
dateend column: 10/20/2005

I would like to return columns for date = 10/15/2005 and not if i enter
let's say date = 10/21/2005

thanks for your help,

Jure Kodzoman