Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 687
This expression for a computed field returns “Not a valid age” if age does not
contain a number. The expression checks whether the Integer function returns
0, which means it failed to convert the value:
If (Integer(age) <> 0, age, "Not a valid age")
This expression returns 0:
Integer("3ABC") // 3ABC is not a number
This validation rule checks that the value in the column the user entered is less
than 100:
Integer(GetText()) < 100
This validation rule for the column named age insures that age contains a
string:
Integer(age) <> 0
See also
IsNumber
IsDate
Description Tests whether a string value is a valid date.
Syntax IsDate ( datevalue )
Return value
Boolean. Returns true if datevalue is a valid date and false if it is not.
Examples This expression returns true:
IsDate("Jan 1, 99")
This expression returns false:
IsDate("Jan 32, 2005")
This expression for a computed field returns a day number or 0. If the
date_received column contains a valid date, the expression returns the number
of the day in date_received in the computed field, and otherwise returns 0:
If(IsDate(String(date_received)),
DayNumber(date_received), 0)
Argument Description
datevalue A string whose value you want to test to determine whether it is a
valid date