validation date

[Guest]

Anyone know where I can find code for validation of the
date. ie. user enters in mmddyyyy, I want to ensure that
the values they enter make sense (eg. month cannot be 33,
has to be between 1-12)

thx.

 

[Kevin]

Try the isDate function.

if(isdate(your date))then
....do your thing
endif

or

if(not isdate(your date))then
Msgbox "This is not a valid date"
exit sub
endif

etc...

Hope that helps!

Kevin