Finding numbers, dates, times, and timestampsWhen you enter criteria in a find request, numbers, dates, times, and timestamps should be entered in the corresponding field types (or calculation fields returning the corresponding field type) to ensure correct behavior when finding them.Important Entering two-digit year dates along with Find operators in a find request will be interpreted as four-digit dates based on a conversion algorithm. For example, entering a find request as 1/1/14 .. 12/31/15 will find the years 2014 through 2015 if the current year is 2014. It is strongly recommended that complete four-digit years be used to avoid possible confusion. For more information about the conversion algorithm, see Conversion of dates with two-digit years.
1 finds 10 finds 0 Note For help entering dates with the drop-down calendar, see Working with data in date fields // finds April 4, 2014 (when the current date is 4/4/2014) 12:53:09 finds 12:53:09 3/3/2014 12:59:09 PM finds 3/3/2014 12:59:09 PM Note Full or short day names (for example, Friday or Fri) are acceptable in day of week searches 5/12/* finds the 12th day of May in any year
5/12 finds the 12th day of May in the current year
*:15 finds times 15 minutes after any hour
1/1/* 7 PM finds timestamps in the 7 o’clock PM hour on January 1st in any year
3. When you’ve entered the find criteria that you want, click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
•