DAY (Report Builder)

Extracts the day of month from a datetime.

Syntax

DAY(datetime)

datetime

Specifies the datetime from which the day is extracted.

Example

Formula	Result
DAY(#5/18/2006 6:43 AM#)	18
DAY(Sell End Date)	Returns the day of the month for each instance of the Sell End Data field. For example, 30, 15, and 3.

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