More information please!

Do you want to select all the records in some table or view where the value of a datetime column is between two dates, or do you want to return a contiguous set of dates, i.e. one row per day between the specified dates.

Also is your date range inclusive? i.e. do you want to include rows associated with the specified end date in your resultset?