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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top