TIMENUM( ) TIMENUM(time_exp$)

 

Time Function Returns a Numeric Value
Returns the Time Value of time_exp$. If no time_exp$ is specified, the current system time is used. If time_exp$ is equal to "hh:mm AM", it returns hh:mm AM.

Examples:

TIMENUM( )

Returns 5:15 PM if the current system time is 05:15 PM.

TIMENUM("1:07 PM")

Returns 01:07 PM.

Note: When using TIMENUM, there is a limit of 23 hours, 59 minutes, and 59 seconds. If this number is exceeded, the time value is considered invalid and 1193.05 will be returned.

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)

 

See also:

NOW( )