Date Search

Date searches must be entered in a particular way depending on whether the date to be searched for is formatted as a date field, or whether the date is simply entered as a text string.

Example: The information on most available search fields in Juris, such as Notecards, Remarks, etc., are stored as text strings.  Searching for a date that is entered in one of these fields would be performed in the same way as any other text string and would be done using the typical search rules.  However, a UDF that is defined as a date field must be searched for in a different manner since it is formatted as a date and stored as such in the database.  Dates must be searched for using the date format of MMM DD YYYY. (Three character month, two character day, four character year.)

Suppose a Matter UDF is created and the date 1/15/2005 is entered there.  A simple search for 1/15/2005 would not find this field.  The search must be entered in the format "MMM DD YYYY", which in this case would be "Jan 15 2005".  Quotation marks should be included.

Wildcard

The ? wildcard may also be implemented in this format.

Example: If all dates in January 2005 are to be returned, the search could be entered as:
"Jan ?? 2005" or Jan AND 2005.  

If all dates in January of any year are to be searched, the search criteria could be entered as:

All dates in January of February could be searched in any of the following ways:

Note: The rule against including the question mark wildcard within quotation marks does not apply to date searches.

Three Character Month Abbreviations:

Related Topics Link IconRelated Topics