MINUTE (Report Builder 1.0)
Extracts the minute from a datetime or a time field type. The result is displayed as an integer (0-59).
Syntax
MINUTE(datetime)
datetime |
Specifies the datetime or time from which the minute is extracted. |
Remarks
- To display a datetime value as a time value, you must format the field to use one of the following custom datetime format strings on the Number tab of the Format dialog box: u, f, or s.
Example
Formula |
Result |
---|---|
MINUTE(NOW( )) |
Returns the minute value for the time at the time the report is run. |
MINUTE(#7/31/2009 10:45:34 AM#) |
45 |