How to check the dates are missing in squence

Question

 

Hi,

 

I have table AAA, Td_No, Td_Date

 

Td_No	Td_Date
1	01/01/02018
2	02/01/2018
3	03/01/2018
4	05/01/2018

 

what i want is if the dates are contine more than two days then pass some flag.

 

con.Open()

cmd6 = New SqlClient.SqlCommand("Select * from AAA order by Td_Date", con)

dr6 = cmd6.ExecuteReader()

If dr6.HasRows Then

While dr6.Read

''here need to check and some flag 

End While

End If

 

thanks

Basit