Dates and SQL server

if isDate("41/33/9009") then
    'Do it
else
    'explode
end if

IsDate will work on the days and months.. but it wont on the year.  someone can still enter in 9009 as a year.. if ya want that kind of thing.

you could do the IsDate and combine it with datediff to make sure that it is in a reasonable range.

If IsDate(dateVariable) Then
   AcceptableDate = DateDiff("y", Now, dateVariable)
  If AcceptableDate >= -5 And AcceptableDate <= 5 Then
    ' date is somewhere between 2000 and 2010