IsDate
PowerScript function
Description
Tests whether a string value is a valid date.
Syntax
|
1 |
IsDate ( datevalue ) |
|
Argument |
Description |
|---|---|
|
datevalue |
A string whose value you want to test to determine whether |
Return value
Boolean.
Returns true if datevalue is a valid date and false if it is not. If
datevalue is null, IsDate returns null.
Usage
You can use IsDate to test whether a user-entered date is valid
before you convert it to a date datatype. To convert a value into a date
value, use the Date function. The year value must be in the range 01 to
9999.
Examples
This statement returns true:
|
1 |
IsDate("Jan 1, 05") |
This statement returns false:
|
1 |
IsDate("Jan 32, 2005") |
If the SingleLineEdit sle_Date_Of_Hire contains 7/1/99, these
statements store 1999-07-01 in HireDate:
|
1 2 3 4 |
Date HireDate IF IsDate(sle_Date_Of_Hire.text) THEN HireDate = Date(sle_Date_Of_Hire.text) END IF |
See also
IsDate method for DataWindows in the section called “IsDate” in DataWindow Reference.