MINUTE( ) MINUTE(time_value)

 

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

Examples:

MINUTE( )

Returns 60,000 (without the commas).

MINUTE(TIME)

Returns 30 if the current system time is 3:30 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)