Determines the month name associated with a specified date value. Syntax $monthname(date) Parameters date a data, or an expression that evaluates to a date, in the form YYYYMMDD Return Value Character string. Comments This function extracts month information from standard date values. Date is often the system variable $Date. The values returned by the $monthname…
Read more
Tests if a character string is a valid date. Syntax $isdate(string) Parameters string a character string or an expression that evaluates to a character string Return Value 1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False). Comments This function tests if a particular character string is…
Read more
Calculates the sine of a number. Syntax $sin(number) Parameters number a number, or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number. Comments The value returned by this function has the same number of decimal places as number. Ensure that you specify enough decimal places…
Read more
Right-justifies a character string. Syntax $rightjustify(string) Parameters string a character string, or an expression that evaluates to a character string Return Value Character string, consisting of string right-justified in a space $length(string) characters long. Trailing blanks in string are ignored. Example $rightjustify(“abcde “) Evaluates to ” abcde”. $rightjustify(var1) Evaluates to ” 3″ if var1 is…
Read more
Sums a set of values, excluding those in which the expression is $Null. Syntax $total(expression) Parameters expression any expression Return Value Number. Comments Expression is often a WHERE expression that includes only selected values in the totalling operation. If the WHERE expression (expr1 WHERE expr2) is true, the expr1 value is included in the operation;…
Read more
Calculates the hyperbolic cosine of a number. Syntax $cosh(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. Ensure that you specify enough decimal places in your equation to ensure a sufficiently granular result. Unusual…
Read more
Calculates the tangent of a number. Syntax $tan(number) Parameters number a number or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number. Ensure that you specify enough decimal places in your equation to ensure a sufficiently granular result. Unusual results such as -0 are an…
Read more
Calculates the cosine of a number. Syntax $cos(number) Parameters number a number, or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number. Comments The value returned by this function has the same number of decimal places as number. Ensure that you specify enough decimal places…
Read more
Calculates the arctangent (in radians) of the quotient of two numbers. Syntax $atan2(number1,number2) Parameters number1 a number, or an expression that evaluates to a number number2 a number, or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number1. Comments Number1 is divided by number2 before…
Read more
Builds a single character string out of separate character strings. Syntax $concat(string[«,string»]) Parameters string A character string or an expression that evaluates to a character string. Each string must be separated from the next by a comma (,). Return Value Character string. Comments The function builds a single character string out of separate strings. Example…
Read more
English 
Portuguese