MORE THAN 6 MONTHS OLD

[bradley7]

hi guys

in vba, i need code to see if a date is greater than 6 months old
eg today is 10/12/2005
need all older than 10/06/2005

ta guys

 

[Leonard of Quirm]

Brad,
Jus' like that:

Dim MyDate As Date

Sub asdfasdf()

MyDate = "10/09/2005"
If Date - MyDate < 182 Then '182 days - substitute your own 6 month value
    MsgBox ("The date is within the last six months.")
Else
    MsgBox ("The date is older than six months from today.")
End If

End Sub

Matt