IsDate
Using the ISDATE Function
In this tutorial you will learn how to use the IsDate Function.
The IsDate function returns a Boolean value indicating whether an expression can be converted to a date
=IsDate( expression )
expression a Date or String representing a Date
In this example we will use the date "18/10/2014".
The result is -1.
 Query
The results using a Query would be
SELECT IsDate(#18/10/2014#);
 FORM
In a Form you could set the Default Value of a Textbox to
=IsDate(#18/10/2014#)
 VBA
In a Form add a TEXTBOX control and rename it "txtIsDate", then you could add the following in the Load Event.
Private Sub Form_Load()
txtIsDate = IsDate(#18/10/2014#)
End Sub
Courses
Access Expert 25
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
