ISDATE

ISDATE(expression)

Returns the value True or False depending if the expression is a date (Boolean).

expression

The expression to test (Variant).

REMARKS

* This function refers to your local settings when determining what format is recognised as a date.
* The "expression" can be a date or a string in a date format.
* This function does recognise date and time literals.
* This function is used a lot to test if a text string can be converted to a date.
* You can use the CSTR function to return an expression converted to a String data type.
* You can use the DATE function to return the current system date.
* You can use the ISARRAY function to return True or False depending if the value is an array.
* You can use the ISEMPTY function to return True or False depending if the variable has been initialised.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISMISSING function to return True or False depending if an optional argument has been passed in.
* You can use the ISNULL function to return True or False depending if the value contains no data.
* You can use the ISNUMERIC function to return True or False depending if the value is a number.
* You can use the ISOBJECT function to return True or False depending if the variable represents an object.
* The equivalent .NET function is [[Microsoft.VisualBasic.Information.IsDate]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print IsDate("01/07/2024")   '= True  
Debug.Print IsDate("01/99")        '= True  
Debug.Print IsDate("01/13/2024")   '= True  
Debug.Print IsDate("13/01/2024")   '= True  
Debug.Print IsDate("12-01-2024")   '= True  
Debug.Print IsDate(CDate(40544))   '= True  
Debug.Print IsDate(40544)          '= False  
Debug.Print IsDate("1")            '= False  
Debug.Print IsDate(12)             '= False  
Debug.Print IsDate("12")           '= False  
Debug.Print IsDate("text")         '= False