@Second (Formula Language)

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


@Second( time-date )



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

Return value


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.


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.


  1. This example returns 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.
  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.