Does any genious out there know? Without using OCX controls or scripting references...?
Like for e.g. "Day/Month/Year", some *stupid* users enter more than 31 days!?!
Printable View
Does any genious out there know? Without using OCX controls or scripting references...?
Like for e.g. "Day/Month/Year", some *stupid* users enter more than 31 days!?!
What are you asking? You want to know if the date is a valid one?
2/31/01 = February 31, 2001 - not a real dateCode:MsgBox IsDate("2/31/01") 'returns false
MsgBox IsDate("3/31/01") 'returns true
3/31/01 - March 31, 2001 - real date
Yep. I just want to know whether they have entered a real(valid) date in the Masked Editbox. * This feature is not there in the Masked Editbox (M$ were meant to be smart... :-))
Also, how would you do it for time in the format:
##:## (AM/PM)... ?!?