@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

  1. This example returns 9.
    @Hour([9:30])
  2. This example returns 9 and 10 in a list.
    @Hour([9:30] : [10:30])
  3. This example returns 8 if the time in the Date field is 8:56:34 AM.
    @Hour(Date)
  4. 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)
  5. This example returns 3 if the current document was created on 2/15/92 at 3:00:12 A.M.
    @Hour(@Created)