DATETIME (Report Builder)
Returns a datetime given the year, month, day, hour, minute, and second.
Syntax
DATETIME(year, month, day, hour, minute, second)
year |
Specifies the integer representing the year. |
month |
Specifies the integer representing the month (1-12). |
day |
Specifies the integer representing the day (1-31). |
hour |
Specifies the integer representing the hour (0-23). |
minute |
Specifies the integer representing the minute (0-59). |
second |
Specifies the decimal representing the second (0-60). |
Example
| Formula | Result |
|---|---|
DATETIME(2008, 8, 5, 6, 57, 32) |
8/5/2009 6:57:32 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)