Formula (Extended): $SECOND Function

2023-12-062024-06-07

Overview¶

Find the number of seconds in a specified date.

$SECOND(Date)

Parameter	Type	Required	Description
Date	Date or date string in yyyy/mm/dd or yyyy/mm/dd hh:MM:ss format	Required	Auto-completes to "00:00:00" in yyyy/mm/dd format.

Parameter	Classification	Numeric Value	Date	Description	Check
Date	Yes	No	Yes	Yes	No

Number of seconds (0 to 59).

Target	Display Content of Return Value
Classification (including title, status, manager, owner)	Display return value. In the case of a drop-down list with values, the options that match the return value are displayed.
Numeric Value (including work volume, progression rate, remaining work volume)	Display return value.
Date (including start and completion)	Do not display.
Description (including content)	Display return value.
Check (including lock)	Do not display.