Function: Month

Description

Returns the month (1-12) from a date.

Syntax

Month(date)

Arguments

date can be a constant, a date field, an expression that results in a date or a function that returns a date.

Return value

This function returns a number in the range 1-12.

Calculated field example

If the Ship_date field contained the value 20010704, the following calculated field expression would return the value 7: Month(Ship_date)

Filter/Find example

Records with a date of 19910114, 19890131 or 19940107 in the Ship_date field can be selected or found using the expression: Month(Ship_date)=1