F

FieldInfo(expC1,expC2,expC3)

Data Format Returned: X

Returns information about a field in a table.

Parameters

Variable Status Description
expC1 Required The name of the physical table or the alias of  the query containing the field.
expC2 Required The name of the field to return information for.
expC3 Required An expression containing the name of the value to return. Valid options are CAPTION, SEQUENCE, DATA_TYPE, LENGTH, DECIMALS. Sequence refers to the fields position in the table or the query fields list.

FindInAlias(expC1,expC2)

Data Format Returned: R

Does not return a display value, but useful in reports to locate a record based on qualifying expression. The alias specified must be in use and a qualifying expression must be specified. The function will return true (.T.) if a qualifying record is found, or false (.F.) if not.

Parameters

Variable Status Description
expC1 Optional Name of alias in which to find record. If not passed, currently selected alias is assumed.
expC2 Required Qualifying expression.

FIPSCo(expC1,expC2)

Data Format Returned: X

Attempts to locate a FIPS county code for a specified state and county name .

Parameters

Variable Status Description
expC1 Required The two letter abbreviation for the state in which the county exists.
expC2 Required County name to find. This function performs a case insensitive search for this county name in the state specified by expC1. A match is found if the name string passed is found anywhere within the county name specified in the lookup table.

FIPSState(expC)

Data Format Returned: X

Attempts to locate a FIPS state code for a specified two-letter state abbreviation.

Parameters

Variable Status Description
expC Required The two letter abbreviation for the state to return the FIPS state code for.

FiscalYear(expD,expN)

Data Format Returned: X

Returns the fiscal year for a specified date value. Return value can be either a 4-character string for the year or the numeric value of the year.

Parameters

Variable Status Description
expD Required The date value to return the fiscal year for.
expN Optional Determines the type of data returned. If passed as zero (0) or not passed, the return value is a 4-character string. If passed as 1, returns the numeric value of the fiscal year.

FiscalYearDate(expD,expN)

Data Format Returned: X

Returns either the starting date or ending date of the fiscal year in which a date value resides.

Parameters

Variable Status Description
expD Required The date value to return the fiscal year starting or ending date value for .
expN Optional

Numeric value indicating the value to return .

  • 1 = Starting date of fiscal year,
  • 2 = Ending date of fiscal year.

If not passed, 1 is assumed.

FLOOR

Data Format Returned: N

Round down to the next lower integer. Rounds a positive number with a fractional portion down to its integer value, and rounds a negative number with a fractional portion down to the next lowest integer.

FmtName(expC1,expC2,expC3,expC4)

Data Format Returned: X

Returns a formatted individual name string in the format Last Name, First NameMiddle.

Parameters

Variable Status Description
expC1 Optional Alias name contain individual name fields.  If not passed, currently selected alias is assumed
expC2 Optional Name of field in alias corresponding to last  name. If not passed, LAST is assumed
expC3 Optional Name of field in alias corresponding to first  name. If not passed, FIRST is assumed
expC4 Optional Name of field in alias corresponding to middle  name. If not passed, MIDDLE is assumed

FmtName(Contact) returns last  name, first name M for the query alias “contact” (Occupancy Contacts report).  The name fields need to be a part of the query.