MinutesBetween()

<cTime1> The starting time as character string formatted as "hh:mm:ss" (24 hour format)

<dDate2> The ending date

<cTime2> The ending time as character string formatted as "hh:mm:ss" (24 hour format)

<lWeekEnds> A logical indicating whether or not to count weekends.

Retorna

MinutesBetween() Retorna the number of minutes between <cTime1> on <dDate1> and <cTime2> on <dDate2>. The first date/time value must be the smaller of the two.

Month()

Propósito

To convert a date value to a month number

Sintaxis

Month( <dDate> ) nMonth

Argumento

<dDate> is the date to convert.

Retorna

Month() Retorna a numeric value in the range of 1 to 12 representing the month of <dDate>.

Num2CDOW()

Propósito

To convert a numeric day number to a character day of the week string

Sintaxis

Num2CDOW( <nDay> ) cDayName

Argumento

<nDay> is the number (1-7) to convert into the day name

Retorna

Num2CDOW() Retorna a character day name.

Num2CMonth()

Propósito

To convert a numeric month number to a character month name

Sintaxis

Num2CMonth( <nMonth> ) cMonthName

Argumento

<nMonth> is the number (1-12) to convert into the month name

Retorna

Num2CMonth() Retorna a character month name.

NumTrim()

Propósito

Retorna the number passed as a left-trimmed string

Sintaxis

NumTrim( <nNumber> ) cString

Argumento

<nNumber> is the number to convert to a string

Retorna

NumTrim() Retorna the value <nNumber> as a left-trimmed string.

OccursIn()

Propósito

To determine how many time one string occurs in another

Sintaxis

OccursIn( <cSearchFor>, <cSearchIn> ) nTimes

Argumentos

<cSearchFor> is the string to search for

<cSearchIn> is the string to search

Retorna

OccursIn() Retorna the number of times <cSearchFor> occurs in <cSearchIn>.

Pad()

Propósito

To pad character, date and numeric values with spaces

Sintaxis

PadC( <xValue> , <nLength>, <cPadChar> ) cPaddedString

PadL( <xValue> , <nLength>, <cPadChar> ) cPaddedString

PadR( <xValue> , <nLength>, <cPadChar> ) cPaddedString

Argumentos

<xValue> is the character, date or numeric value to pad

<nLength> is the length of the string to return

<cPadChar> is the character to pad with

Retorna

PadC() Retorna <xValue> as a character string of length <nLength> centered between <cPadChar>. PadL() Retorna <xValue> as a character string of length <nLength> padded with <cPadChar> on the left side. PadR() Retorna <xValue> as a character string of length <nLength> padded with <cPadChar> on the right side.

Power()

Propósito

To raise a number by a power

Sintaxis

Power( <nNumber>, <nExponent> ) nTimes

Argumentos

<nNumber> is the base number

<nExponent> is the power to raise the base number by

Retorna

Power() Retorna <nNumber> raised to the power of <nExponent>.

PgCount()

Propósito

To retrieve the ReportPro page count.

Sintaxis

PgCount() nCount

Retorna

PgCount() Retorna the internal ReportPro page number count. This function will only return a meaningful value if the "Support Total Page Count" option is set in the Report Configuration dialog.

PgNo()

Propósito

To retrieve the ReportPro page number

Sintaxis

PgNo() nPage

Retorna

PgNo() Retorna the internal ReportPro page number.

Properize()

Propósito

To change the first character of each word in a string to upper case

Sintaxis

Properize( <cString> ) cProperString

Argumento

<cString> is the string to modify

Retorna

Properize() Retorna <cString> with the first character of each word in uppercase.

Rand()

Propósito

To retrieve a random number between 0 and 1

Sintaxis

Rand( <nSeedNumber> ) nRandomNumber

Argumentos

<nSeedNumber> is a number used to seed the random number generator

Retorna

Rand() Retorna a random number.

RAt()

Propósito

To retrieve the last position of one string within another

Sintaxis

RAt( <cSearchFor>, <cSearchIn> ) nLocation

Argumentos

<cSearchFor> is the string to search for

<cSearchIn> is the string to search

Retorna

RAt() Retorna the last location of <cSearchFor> in <cSearchIn>.

Replicate()

Propósito

To create a string by repeating another string

Sintaxis

Replicate( <cString>, <nTimes> ) cNewString

Argumentos

<cString> is the string to repeat

<nTimes> is the number of times to repeat <cString>

Retorna

Replicate() Retorna <cString> repeated <nTimes>.

Right()

Propósito

To retrieve a substring beginning with the rightmost character

Sintaxis

Right( <cString> , <nCount> ) cSubString

Argumentos

<cString> is the character string from which to extract characters.

<nCount> is the number of characters to return.

Retorna

Right() Retorna the rightmost <nCount> characters of <cString>.

Round()

Propósito

To return a numeric value rounded to a specified number of digits.

Sintaxis

Round( <nNumber> , <nDecimals> ) nRounded

Argumentos

<nNumber> is the numeric value to round.

<nDecimals> is the number of decimals places to retain.

Retorna

Round() Retorna a numeric value rounded to <nDecimals> decimals.

RpEOF()

Propósito

To return a logical indicating if ReportPro has reached the end of the report.

Sintaxis

RpEOF() lEOF

Retorna

RpEOF() Retorna TRUE if ReportPro has finished processing all records in the report.

RpSQLCol()

Propósito

To retrieve a SQL column value by column position number.

Sintaxis

RpSQLCol( <nColumn> ) xColumnValue

Argumento

<nColumn> is the number of the column to retrieve

Retorna

RpSQLCol() Retorna the value of the column that occupies the <nColumn> position in the SQL select statement.

Sec2Days()

Propósito

To convert seconds to days

Sintaxis

Sec2Days( <nSeconds> ) nDays

Argumento

<nSeconds> is the number of seconds to convert to days

Retorna

Sec2Days() Retorna <nSeconds> converted to days.

Sine()

Propósito

To calculate the sine of a number

Sintaxis

Sine( <nAngle> ) nSine

Argumento

<nAngle> is the angle in radians

Retorna

Sine() Retorna the sine of <nAngle>.

Space()

Propósito

To return a string of spaces

Sintaxis

Space( <nCount>) cString

Argumento

<nCount> is the number of spaces to return.

Retorna

Space() Retorna a string of <nCount> spaces.

SqRt()

Propósito

To calculate the square root of a positive number

Sintaxis

SqRt( <nNumber> ) nRoot

Argumento

<nNumber> is the positive number to calculate the square root of

Retorna

SqRt() Retorna the square root of <nNumber>.

Str()

Propósito

To convert a numeric expression to a character string

Sintaxis

Str( <nNumber> , <nLength> , <nDecimals> ) cNumber

Argumentos

<nNumber> is the numeric value to convert

<nLength> is the length of string to return including decimals and decimal point