Finding numbers, dates, times, and timestamps
When 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.
To find numbers, dates, times, and timestamps:
1.
See Making a find request.
2.
 
.50 finds .5, .50, and $.50
# finds 3 but not 30
## finds 30 but not 3 or 300
#3 finds 53 and 43 but not 3
1 to find True values
0 to find False values
1 finds 1
0 finds 0
? finds twelve but not 12 or twelve30
Note  For help entering dates with the drop-down calendar, see Working with data in date fields
3/3/2014 finds 3/3/2014, March 3, 2014, and 3-3-2014
// 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
? finds Next Tuesday or 2/33/2014 in a date field, or midnight in a time field
Note  Full or short day names (for example, Friday or Fri) are acceptable in day of week searches
Tuesday finds all dates that occur on a Tuesday
=Thu finds all dates that occur on a Thursday
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.
Notes
 •
 •
 •
Related topics 
About number fields
About date fields
About time fields
About timestamp fields