Search:

@DataMiser: I know, it really infuriates me when people spread complicated, slow, buggy ways of doing something which can be done easily, quickly and correctly. The reason I went into so much detail...

I'll just post the code here as well so people don't have to download the zip file if they just want to see it. The comparisons are highlighted in red:
Private firstDate As Date
Private secondDate...

Karl's reputation is completely irrelevant here. Once you have a piece of code, whether it is correct or not does not depend upon the author's reputation. It depends solely upon whether, when you run...

Thanks for that correction dglienna. According to this link (http://msdn.microsoft.com/en-us/library/aa243311(v=vs.60).aspx) the valid range is January 1, 1980 through December 31, 2099 (for Win95)...

I found this piece of code by hensa22 in the original reply to this thread. Works great. I have not tested it because there is not need to - the documentation says it works for any date which can be...

Yes, use date1 > date2. This will work for any two dates.
Why don't you use this? :confused:

That is a great way to do it when the following conditions apply:

Efficiency isn't a concern
Getting the correct answer isn't, either :rolleyes:

Your method compares dates in lexical order...