SECOND( ) SECOND(time_value)

 

Time Function Returns a Numeric Value
Returns the value of the time_value in seconds (0-59 or 1,000). If the time_value is blank, then returns 1,000 (i.e., the number of milliseconds in one second). If the time_value is equal to "hh:mm AM", then returns -1.

Examples:

SECOND( )

Returns 1,000 (without the commas).

SECOND(TIMENUM())

Returns 54 if the current system time is 3:30:54 PM.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)