DAY (Report Builder 1.0)

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.