Time of day function rule examples

Time of day functions are used with time of day variables to set the time of day, to extract the second/minute/hour from a time of day, and to get an earliest/latest time of day.

Be sure to use the exact syntax for these functions including spacing and parentheses as specified below.

TIP: The localized syntax for these functions may be viewed:

Rule examples

Function Example rule Inputs Outputs
TimeOfDay

the latest submission time = TimeOfDay(the submission time specified on the application form)

the submission time specified on the application form: 12:30:00 the latest submission time = 12:30:00
ExtractSecond

the second component of the submission time = ExtractSecond(the submission time)

the submission time: 14:42:32 the second component of the submission time = 32
ExtractMinute

the minute component of the submission time = ExtracMinute(the submission time)

the submission time: 14:42:32 the minute component of the submission time = 42
ExtractHour

the hour component of the submission time = ExtractHour(the submission time)

the submission time: 14:42:32 the hour component of the submission time = 14
ExtractTimeOfDay

the time of the assessment = ExtractTimeOfDay(the current date time)

the current date time: 2009-09-04 10:46:12 the time of the assessment = 10:46:12
Latest (uses the Maximum function)

the latest finish time = Maximum(the finish time of James, the finish time of Mary)

the finish time of James: 11:15:08

the finish time of Mary: 11:13:42

the latest finish time = 11:15:08
Earliest (uses the Minimum function)

the earliest completion time = Minimum(the completion time of Team A, the completion time of Team B)

the completion time of Team A: 16:45:02

the completion time of Team B: 16:14:18

the earliest completion time = 16:14:18

 

See also: