UNICOM Intelligence Interviewer - Server stores date and time responses as a date and time string. The way to test dates and times is to extract the date or time component that you want to test as a numeric value and then write an arithmetic expression to test that value.

There are a number of functions that work with dates and times; the ones you are most likely to use are as follows:

For information about other date and time manipulation functions, see Date and time functions.

To test the value returned by these functions, use the following operators:

In the following examples, assume that the answer to the performance question is 22 December 2004 2:30pm.

To test the day part of a date, use the Day function which returns a value in the range 1 to 31. For example:

returns False because the date is later than the 20th of the month.

To test the month part of a date, use the Month function which returns a value in the range 1 to 12. For example:

returns True because the performance date is later than month 6 (June).

To test the year part of a date, use the Year function. For example:

returns False because the performance date is during 2004.

To test the hour part of a date, use the Hour function which returns a value in the range 0 to 23. If the time is entered in 12-hour format, times with a pm tag are converted to their 24-hour equivalents. For example:

returns True because the performance time is in the afternoon.

To test the minute part of a date, use the Minute function which returns a value in the range 0 to 59. For example:

returns False because the performance time shows 30 minutes.