@Hour (Formula Language)
Returns the number of the hour in the specified time-date.
Syntax
@Hour( timeDateValue )
Parameters
timeDateValue
Time-date or time-date list. The value with the hour that you want to extract.
Return value
hour
Number or number list. A number representing the hour contained in timeDateValue. Hours are represented as 0 through 23 for 12 AM through 11 PM. Returns -1 if the time-date provided contains only a date and not a time value.
Usage
If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.
Examples
- This example returns 9.
@Hour([9:30])
- This example returns 9 and 10 in a list.
@Hour([9:30] : [10:30])
- This example returns 8 if the time in the Date field is 8:56:34
AM.
@Hour(Date)
- This example returns 20 if a Date field is made up of the date
and time: 7/30/90 8:56:34 PM.
@Hour(Date)
- This example returns 3 if the current document was created on
2/15/92 at 3:00:12 A.M.
@Hour(@Created)