compare dates

[wafabekhti]

How do I compare 2 dates (mm/dd/yy) to let the user know which one is dated earlier.
when I used
if date1 < date2 then
do this
it is comparing the months only.

 

[zemp]

What data type are the variables 'date1' and 'date2'?

If they are date types then your code should work. If they are strings try,

If CDate(date1) < CDate(Date2) then...

Take Care,

zemp

&quot;If the grass looks greener... it's probably because there is more manure.&quot;