IsDate Function |
No
IsDate(expression)
expression
Use: Required
Data Type: Variant
Variable or expression containing a date or time.
Boolean (True or False).
Determines if a variable's value can be converted to a date.
If the expression passed to IsDate is a valid date, True is returned; otherwise, IsDate returns False.
IsDate uses the locale settings of the current Windows system to determine if the value held within the variable is recognizable as a date. Therefore, what is a legal date format on one machine may fail on another.
IsDate is particularly useful for validating data input. However, don't use IsDate in the VB text box control's Change event. The Change event is fired with every keystroke, which means that when the user starts to enter the date, the chances are that the date will be invalid until the point at which the user has completed the data entry.