@Second (Formula Language)

Extracts and returns the seconds value from the specified time-date.

Syntax

@Second( time-date )

Parameters

time-date

Time-date or time-date list. The value with the second that you want to extract.

Return value

seconds

Number or number list. The number of seconds in the second part of the time. 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 45.
    @Second([9:30:45])
  2. This example returns 45 and 46.
    @Second([9:30:45] : [9:30:46])
  3. This example returns 45 if the current time is 12:30:45 P.M.
    @Second(@Now)
  4. This example returns 45 as a text string if the contents of the field named Date is any time-date value in which the number of seconds is 45.
    @Text(@Second(Date))