Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 717
Return value Time. Returns the current time based on the system time of the client machine.
Usage Use Now to compare a time to the system time or to display the system time on
the screen. The timer interval specified for the form or report determines the
frequency at which the value of
Now is updated. For example, if the timer
interval is one second, it is updated every second. The default timer interval is
one minute (60,000 milliseconds).
Examples This expression returns the current system time:
Now()
This expression sets the column value to 8:00 when the current system time is
before 8:00 and to the current time if it is after 8:00:
If(Now() < 08:00:00, '08:00:00', String(Now()))
The displayed time refreshes every time the specified time interval period
elapses.
See also If
Year
Number
Description Converts a string to a number.
Syntax Number ( string )
Return value
A numeric datatype. Returns the contents of string as a number. If string is not
a valid number, Number returns 0.
Examples This expression converts the string 24 to a number:
Number("24")
This expression for a computed field tests whether the value in the age column
is greater than 55 and if so displays N/A; otherwise, it displays the value in age:
If(Number(age) > 55, "N/A", age)
This validation rule checks that the number the user entered is between 25,000
and 50,000:
Number(GetText())>25000 AND Number (GetText())<50000
Argument Description
string The string you want returned as a number