DATE (Report Builder)
Returns a datetime value given a year, month, and day at 12:00:00 AM.
Syntax
DATE(year, month, day)
year |
Specifies the integer representing the year as a four digit number. |
month |
Specifies the integer representing the month (1-12). |
day |
Specifies the integer representing the day (1-31). |
Example
| Formula | Result |
|---|---|
DATE(2004, 1, 25) |
1/25/2004 12:00:00 AM |
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 Data, Text, and Images (Report Builder)