We can't help you with anything specific - your question is just too vague, and we have no idea where you might be stuck.
But basically, you need to issue an SQL Command using the
DELETE
syntax with a
BETWEEN
condition in the
WHERE
clause:
DELETE FROM MyTable WHERE myDateColumn BETWEEN startDate AND endDate
This may help:
Using con As New SqlConnection(strConnect)
con.Open()
Using com As New SqlCommand("DELETE FROM MyTable WHERE myDateColumn BETWEEN @START AND @END", con)
com.Parameters.AddWithValue("@START", mystartDateTime)
com.Parameters.AddWithValue("@END", myEndDateTime)
com.ExecuteNonQuery()
End Using
End Using