1. Home
  2. Computing & Technology
  3. Databases

Microsoft Access Function Library: IsDate()

By Mike Chapple, About.com

Function: IsDate()

Purpose: The IsDate function returns a value of true if the referenced variable is a date or time. Otherwise, it returns false.

Usage: IsDate(variable_name)

Where variable_name is the name of the variable you wish to test.

Returns: True if the referenced variable is a date or time; False otherwise.

Example
TestArray = Array(1,2,3)
TestInt = Int(1)
TestDate = "June 10, 2000"
IsDate(TestArray) returns False
IsDate(TestInt) returns False
IsDate(TestDate) returns True
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Access Function Library
  6. Microsoft Access Function Library: IsDate()>

©2009 About.com, a part of The New York Times Company.

All rights reserved.