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:
Function | Example rule | Inputs | Outputs |
---|---|---|---|
TimeOfDay |
|
the submission time specified on the application form: 12:30:00 | the latest submission time = 12:30:00 |
ExtractSecond |
|
the submission time: 14:42:32 | the second component of the submission time = 32 |
ExtractMinute |
|
the submission time: 14:42:32 | the minute component of the submission time = 42 |
ExtractHour |
|
the submission time: 14:42:32 | the hour component of the submission time = 14 |
ExtractTimeOfDay |
|
the current date time: 2009-09-04 10:46:12 | the time of the assessment = 10:46:12 |
Latest (uses the Maximum function) |
|
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 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: