Date Compared to Logical Date

[Dayo312]

I have 3 variables ( all integers)
and I would like to know if I can
use some function to see if they
are more then 90 days in the past
or more..

And if they are have a MSGBOX say
"This day is older then 90 days"

??

Evan

[Gen-X]

Now I am curious....

You are listed as as senior member... have 142 posts under your belt and yet you are asking a question whose answer is found very simply in the help files for Visual Basic.

Mmmmm....

Anyway.

If Date() - DateSerial(yearvar,monthvar,dayvar) > 90 Then
   MsgBox "This day is older than 90 days"
End If

Perhaps you could let me know how it was you couldn't find these functions.... I am very interested in writing an article on helping people who don't know their way around VB very well and perhaps by understanding the process you went through in trying to solve this problem before asking people on here I can write that article better.

[Dayo312]

Well I didnt know that was in the help files...
But thankyou...