Function: Time

Description

Returns the time portion of a date/time or the current time. Must be formatted as a Time format.

Syntax

Time([date])

Arguments

Date/time (optional).

Return value

This function returns a date/time.

Calculated field example

The following calculated field will return 12:05:33 AM from a Date field containing 11/1/2003 12:05:33 AM: Time(Date)