Question: Using VBScript, how can I determine if a variable is a valid date or not? [ Print this FAQ]
Answer: Use the
IsDate accepts a variable as a single parameter and returns a boolean value - True if the variable can successfully be converted to a date and false if it cannot.
Dim dtValidDate, dtNotValid
dtValidDate = "08/01/78" dtNotValid = "Scott" If IsDate(dtValidDate) then Response.Write (dtValidDate & " is valid<BR>") Else Response.Write (dtValidDate & " is NOT valid<BR>") End If If IsDate(dtNotValid) then Response.Write (dtNotValid & " is valid<BR>") Else Response.Write (dtNotValid & " is NOT valid<BR>") End If
The output of the above script is:
08/01/78 is valid
Scott is NOT valid For more information be sure to read the technical docs.
FAQ posted by Scott Mitchell at
9/24/2000 3:28:28 PM to the
Dates and Times category.
This FAQ has been viewed 53,379 times.
Do you have a FAQ you'd like to suggest?
Suggestions? Comments? If so,
send it in!
Also, if you'd like to be a FAQ Admin (creating/editing FAQs),
let me know! If you are looking for other FAQs, be
sure to check out the 4Guys
FAQ and Commonly Asked Messageboard Questions!
Most Viewed FAQs: 1.) How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. ( 761643 views)
2.) I am using Access and getting a 80004005 error (or a (
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem?
3.) How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? ( 202549 views)
4.) How can I quickly sort a VBScript array? ( 196039 views)
5.) How can I find out if a record already exists in a database? If it doesn't, I want to add it. ( 156019 views)
6.) How do I display data on a web page using arrays instead of Do...While...MoveNext...???... ( 152331 views)
7.) When I get a list of all files in a directory via the (
FileSystemObject, they aren't ordered in any reasonable way.
How can I sort the files by name? Or by size? Or by date created? Or...
8.) For session variables to work, must the Web visitor have cookies enabled? ( 110162 views)
9.) Can I send emails ( without using CDONTS? 107083 views)
10.) How can I take the result of a ( SELECT...MULTIPLE or a group of same-named checkboxes and turn it into a query? That is, if the user selects 3 answers, how can I construct a query that looks for all 3? 106308 views)
Last computed at 9/17/2007 3:22:00 AM