Category: Functions

Extracts seconds information from a standard time value. Syntax $seconds(time) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT Return Value Number. Comments The system variable $Time is often used for time. Example $seconds($Time) Evaluates to 59 when $Time has the value 23595999.…
Read more

Determines which exponent of base 10 yields a given value. Syntax $log10(number) Parameters number a positive number or an expression that evaluates to a positive number Return Value Number, with the same number of decimal places as number. Example let var1=$log10(100) The above expression means “the exponent of base 10 that yields the value 100”…
Read more

Determines which exponent of the natural base (e) yields a given value. Syntax $log(number) Parameters number a positive number or an expression that evaluates to a positive number Return Value Number, with the same number of decimal places as number. Example $log(7.389) The above expression means “the exponent of the natural base that yields the…
Read more

Extracts “hours” information from a standard time value. Syntax $hours(time) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT Return Value Number. Comments The system variable $Time is often used for time. Example $hours($Time) Evaluates to 23 when $Time has the value 23595999.…
Read more

Calculates the hyperbolic sine of a number. Syntax $sinh(number) Parameters number a number, or an expression that evaluates to a number, representing an angle (in radians) Return Value Number, with the same number of decimal places as number. Comments This function calculates the hyperbolic sine of a number. Example let vAngle = $sinh(3.000) Evaluates to…
Read more

Calculates the hyperbolic cosine of a number. Syntax $tanh(number) Parameters number a number, or an expression that evaluates to a number, representing an angle (in radians) Return Value Number, with the same number of decimal places as number. Comments This function calculates the hyperbolic tangent of a number. Example let vAngle = $tanh(3.000) Evaluates to…
Read more

Returns the number of the disk file associated with a specified object. Syntax $filenum(objname) Parameters objname The name of an EntitySet, relationship, application directory, or application document. Return Value For EntitySets, relationships, and application directories, $filenum returns the number associated with the file that contains the specified object. For application documents, $filenum returns the number…
Read more

Set the properties of an ActiveX object. Syntax $ObjSet[Property] (Object, PropertyName, <>) Parameters Object an object variable or formfield of type OLE PropertyName a string or an expression that evaluates to a string PropertyValue one or more strings, expressions or variables Return Value Returns a result of TRUE if successful. Comments This syntax can be…
Read more

Converts a number to a monetary format. Syntax $money(number) Parameters number a number, or an expression that evaluates to a number Return Value Number, with two decimal places. Comments Use $money to convert a number into a monetary number (i.e., with two decimal places). Number is rounded if necessary. Example $money(101.325+48.674) Evaluates to 150.00. See…
Read more

Extracts “ticks” information from a standard time value. Syntax $ticks(time) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT Return Value Number. Comments The system variable $Time is often used for time. With operating systems whose clocks do not support hundredths of a…
Read more