Or you could try:

Code:
If Format("14/11/2012", "dd-mm-yy") > Format(Now, "dd-mm-yy") Then
    Debug.Print "Bigger"
Else
    Debug.Print "Smaller"
End If
Datediff:

Code:
If DateDiff("d", Now, "14/11/2012") > 0 Then
    Debug.Print "Bigger"
Else
    Debug.Print "Smaller"
End If