DATETIME (Report Builder 1.0)
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 |