Usinf VBA to run a IF/AND statement

[scrandal]

How do I write a VBA IF statement that includes a AND section. The code below is what I tried and it didn't work. Any suggestions?

If Now() >= #12/1/2005# And Now() < #12/4/2004# Then
Msg Box "Message to user"
End If

 

[Smitty]

How's this:

    If Now >= #12/1/2005# And Now < #12/31/2005# Then
        MsgBox "Message to user"
    End If

But how could your test evaluate correctly? >= 12/1/2005 AND < 12/4/2004?

Hope that helps,

Smitty

 

[scrandal]

That was a typo on my post, I had it my code as 2005. I tried it a again and it seemed to work with a minor tweek. Thanks for the quick response.

Steve