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 entered as a text string.
For example, the information on most available search fields 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 User Defined Field. UDF's may be established in the Juris database (while in Maintenance Mode) under Setup Manage Define Fields. 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 MMMAn abbreviation for month when formatted using 3 characters as follows: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, DecDDA 2-character abbreviation for day in a date field.YYYYA 4-character abbreviation for year in a date field. . (Three character month, two character day, four character year.) Quotation marks should be used when the Suppose a MatterA specific situation that is being addressed for a Client by the firm. A Client may have many Matters, but each Matter is associated with only one Client. 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.)
Three Character Month Abbreviations:
- Jan
- Feb
- Mar
- Apr
- May
- Jun
- Jul
- Aug
- Sep
- Oct
- Nov
- Dec