Sql Server And Dates

Hi,

My ultimate goal is to display records within a date range. I am using dropdown lists populated from the database as start and end dates for the ultimate SQL Statement. The field is a smallDateTime type.

The begining date populates without todays date using the following:

connection.Open();

//Auto fill fields

SqlCommand command = new SqlCommand("Select distinct CONVERT(NVARCHAR(10),insertDate,101) as iDate from surveyOwner order by iDate DESC", connection);

command.ExecuteNonQuery();

SqlDataReader reader = command.ExecuteReader();

while (reader.Read())

{

FirstDate.DataTextField = "iDate";

FirstDate.DataSource = reader;

FirstDate.DataBind();

}

connection.Close();

}

It works great except records with todays date are excluded throughout.

I was hoping there was something small I was missing.

Thanks,

Doug