compare date field to current date

[Michael Haas]

Need some hwlp with comparing a date field retrieved from an access
date base to the current date. Basically I'm looking to create and if
statement like:
If strArticleDate < = Current Date then
else...

Thanks for any help or feedback
Mike

 

[Tom B]

Try using DateDiff

if DateDiff("d",strArticleDate, CurrentDate)>0 then
'whatever

 

[Mike Haas]

I'm having a problem witht he currentdate part:
if I substitute "02/15/2004" for CurrentDate it works
Do I need to format CurrentDate? how should I decalre it?
Thanks for the help again.
Mike

 

[Aaron Bertrand [MVP]]

You shouldn't have to worry about formatting.

WHERE dateColumn <= Date()

or better yet, if dateColumn has time information,

WHERE dateColumn < DATEADD("d", 1, Date())

 

[Mike Haas]

That did the trick, thanks