Share via


MONTH (Report Builder)

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)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance