Code:Private Sub checkReturnedDate() Dim rownumber As Integer = "0" For Each row In DataGridView1.Rows If Not DataGridView1.Item("Datereturned", rownumber).Value() = "" Then Dim DateReturned As Date = DataGridView1.Item("Datereturned", rownumber).Value() Dim twoweeksago As Date = Date.Today.AddDays(-14) If DateReturned < twoweeksago Then Console.Write(DateReturned) End If End If rownumber = rownumber + 1 Next End Sub
Basically, the field may be blank, or it is in the format 19-08-2010. I want to find any dates which are over 2 weeks from today. It seems to work ok, but just wanted to see if this was the best way to do it.
Thanks




Reply With Quote