shots/contents.gifshots/index.gifshots/prev1.gifshots/next0.gif shots/home.jpg

Searching for Dates in Fields

The Verity Query Language includes a set of relational operators that enable you to search for dates in document fields. Using these operators, you can find documents that were created before, after, or on a specific date. Searching by date can help you focus a search by excluding documents that do not match the date you specified from the results list.

Tip

The date field must be defined for this product otherwise the search will not produce any results. This field is not defined for all products.

Relational Operators

You can use the following Verity Query Language relational operators to specify dates, date ranges, and other numeric values in document fields:

Operator
Description
=
Equal to
<
Less than
<=
Less than or equal to
>
Greater than
>=
Greater than or equal to

Examples of Searching Date Fields

You can search for documents by dates alone or in combination with a search for words or phrases in the text.

You can search for all documents with same date by using this query:

You can search for all documents after a certain date by using this query:

You can search for all documents that contain the word inspection after a certain date by using this query:

shots/contents.gifshots/index.gifshots/prev1.gifshots/next0.gif shots/home.jpg