M
MDY
Data Format Returned: D
MDY
displays a date in Month Day Year format, such as August 24, 1996
.
MDY(lst.alm_date)
returns the date filed in the
following format: June 5, 2002
.
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. |
MONTH(lst.alm_date)
returns the numeric
month number 1 for January, 2 for February, etc.
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. |