@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
- This example returns 45.
@Second([9:30:45]) - This example returns 45 and 46.
@Second([9:30:45] : [9:30:46]) - This example returns 45 if the current time is 12:30:45 P.M.
@Second(@Now) - 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))