MONTH (Report Builder 1.0)

Returns the month from a datetime.

Syntax

MONTH(datetime)

datetime

Specifies the datetime from which the month is extracted.

Example

Formula	Result
MONTH(Due Date)	Returns a month for each instance of the Due Date field similar to the following: 1 4 2
MONTH(#10/30/2010#)	10

See Also

Concepts

Working with Formulas (Report Builder 1.0)

Using Functions (Report Builder 1.0)

Date and Time Functions (Report Builder 1.0)

Report Builder 1.0 How-to Topics

Working with Literals in Formulas and Filters (Report Builder 1.0)

Formatting Numerical Data (Report Builder 1.0)