Greater than relational operator

The greater than (>) relational operator can be used to query any field type. It is most frequently used to query date and time fields because the values returned include seconds, which makes using the equal to (=) operator for date and time fields impractical.

Example Scenario:

Suppose you want to find records opened at 11:00 AM on June 1. Since it is not likely that the record was opened at exactly at 11:00 AM and zero seconds (11:00:00). You are more likely to get the results you want by using a range of times. For example, if you type >06/01/2008 11:00 in the open.time field, all records opened after 11:00 AM, starting with 11:00:01, are returned.

Related topics

Relational operators
Wildcard characters
Retrieving records by using the record list method
Retrieving records using the Query window method

Use the equal to relational operator
Use the less than relational operator
Use the like relational operator
Use the greater than relational operator
Use the starts with relational operator
Perform IR Expert queries