Shayon
Broken In
Well, I've been trying to compare dates using the CDate() function. For example, I wish to compare 5th of June, 2007 and 2nd of July, 2008. Now, everytime I try comparing these dates as :
The answer I get is True because it treats them as 05062007 and 02072007 (at least, that's wot it seems) and ofcourse, 05062007 is larger.
I feel it'd help me if, right when a form loads, I could specify my default date format as yyyy/mm/dd. Could you please let me know how to do that effectively?
Or, it'd even help a lot if you could tell me how to compare dates, more efficiently!!
Code:
MsgBox CDate("05/06/2007") >= CDate("02/07/2007")
I feel it'd help me if, right when a form loads, I could specify my default date format as yyyy/mm/dd. Could you please let me know how to do that effectively?
Or, it'd even help a lot if you could tell me how to compare dates, more efficiently!!