instead of doing this, how can I make this in SQL?Code:
Set rs = db.OpenRecordset("SELECT * FROM COMPUTER_LIST")
If rs.RecordCount = 0 Then
Else
With rs
DateDiffValue = DateDiff("d", CDate(!created_date), Date)
If DateDiffValue > 10 Then
'Display Here
End If
End With
End If
Code:Set rs = db.OpenRecordset("SELECT * FROM COMPUTER_LIST WHERE create_date > dateadd(day,10,date)")