SECOND

This function returns just the second from a date time field.

SECOND( <date_field or date> )

  • date_field or date: A date field or value.

Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.

Example: create a field on the ISSUE table that gives the second that an issue was fixed.

SECOND( [ISSUE.Done Date And Time] )