M

MDY

Data Format Returned: D

MDY displays a date in Month Day Year format, such as August 24, 1996.

MINUTE

Data Format Returned: T

MINUTE returns the numeric minute portion of a date/time field.

MONTH(expD)

Data Format Returned: Character

MONTH displays the numeric month number (1-12) for a date field. An example use for this function might be analysis of fire calls by month.

Parameters

Variable	Description
expD	Specifies the date expression from which the month number returned.

MultiListDetail(expC1,expC2,expC3,expC4,expC5)

Data Format Returned: X

Returns a detailed list of child records based on a key expression.  Information for each child record can span multiple lines, and an extra line is placed between each child record.  Report variables are used for each lines expression.

Parameters

Variable	Status	Description
expC1	Required	Name of alias or table name containing expression to retrieve. This can be the name of an alias already in use, or can point to a physical table name, in which case the alias name does not have to be in use.
expC2	Optional	Qualifying expression. Only records which meet this criteria are queried. If not passed, all records in expC1 qualify. Caution: If expC1 is a table, not specifying a qualifying expression will result in a listing for all records in that table.
expC3	Required	Base name of variables containing expression to return. If records are found in expC1 based on qualifying expression in expC2, then expC3[1..n] is evaluated against each record found and a separate section containing those values concatenated is returned for each record.
expC4	Optional	Internal Line Separator.  This string is inserted between each of the expC3[1..n] evaluations. If not passed, Carriage Return and Line Feed are assumed.
expC5	Optional	External Line Separator.  This string is inserted between child records. If not passed, 2 Carriage Returns and Line Feeds are assumed.