MMOF

The MMOF function returns an integer in the range of 1 to 12, giving the month in which a specified date falls. The result returned by MMOF has the same dimensions as the specified DATE expression.

Return Value

INTEGER

Syntax

MMOF(date-expression)

Arguments

date-expression: An expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to-DATE Conversion".

Notes

TEXT-to-DATE Conversion

In place of a DATE expression, you can specify a text expression that has values that conform to a valid input style for dates. The values of the text expression are converted automatically to DATE values, using the current setting of the DATEORDER option to resolve any ambiguity.

Examples

Example 17-5 Finding the Current Month

The following statement determines the month in which today's date falls.

SHOW MMOF(TODAY)

When today's date is January 15, 1996, this statement produces the following output.