DDOF

The DDOF function returns an integer in the range of 1 through 31, giving the day of the month on which a specified date falls. The result returned by DDOF has the same dimensions as the specified DATE expression.

Return Value

INTEGER

Syntax

DDOF(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 expressions are automatically converted to DATE values using the current setting of the DATEORDER option to resolve any ambiguity.

Examples

Example 9-40 Finding Today's Day of the Month

The following command returns the day of the month on which today's date falls.

SHOW DDOF(TODAY)

When today's date is September 8, 2000, this command produces the following output.