Reply to Message

Can't ignore TIME component
Although the author states that TIME is beyond the scope of his article, you can't ignore it. It's there in every DATE. If you're looking for equal dates, use the INT function. Other math functions can be performed on dates as well.

if Int(MyDateA) = Int(Now()) then
'MyDateA is today, no matter what time it is.
end if

For my non-USA colleagues, the format of a Date Literal (#02/01/2006#) is defined in the documentation. If you'd like to use your local format, just write a simple string manipulator function to move the digits around.
Posted by TomMerritt
24th Feb 2006