How to compare 2 dates in VBA

[Joy]

I use

If FormatDateTime('3/1/2009', vbShortDate) < FormatDateTime("6/2008",
vbShortDate) = True Then
....


the result is that 3/1/2009 is before 6/2008, which is apparently wrong.

Thanks

 

[Jan De Messemaeker]

Hi Joy,

When I replace the single quotes by double quotes I get teh right answer.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jack Dahlgren MVP]

I would not compare the date strings as string comparison may give you
different results than expected. I'd compare the date value.
if dateValue("3/1/2009") ...

-Jack Dahlgren

 

[Joy]

Yes. I found I need to dim it as date instead of string.
Then, it works for me
Thank you!