| IsDate Function |
Named Arguments
No
Syntax
IsDate(expression)
expression
Use: Required
Data Type: Variant
Variable or expression containing a date or time.
Return Value
Boolean (True or False).
Description
Determines if a variable's value can be converted to a date.
Rules at a Glance
If the expression passed to IsDate is a valid date, True is returned; otherwise, IsDate returns False.
Programming Tips and Gotchas
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access