Try:
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand com = new SqlCommand("SELECT * FROM myTable ORDER BY date DESC", con);
SqlDataReader r = com.ExecuteReader();
if (r.Read())
{
Console.WriteLine((DateTime) r["date"]);
}
r.Dispose();
com.Dispose();
con.Dispose();
The "ORDER BY" and "DESC" parts tell it to return the rows in a specific order (in this case by the "date" column) with the newest first.