month

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)