Type
Date Function

Purpose
The month function extracts the month (1- 12) from a date value.

Syntax
month( DATE VALUE)

Returns
An integer value between 1 and 12
The date format selected using the International option in the Windows Control Panel changes the date sequence but does not affect which value is returned by a Date function.

Examples
month( 12/31/99)
Returns: 12 ( North American format)

month( 31/12/99)
Returns: 12 (European format)

month( 99/12/31)
Returns: 12 (Metric format)