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)