To find | Type this in the field | Examples |
A number in a number field or in a calculation field that produces a numeric result | The number | .50 finds .5, .50, and $.50 |
One or more digits in a number field or in a calculation field that produces a numeric result | A # character for each digit | # finds 3 but not 30 ## finds 30 but not 3 or 300 #3 finds 53 and 43 but not 3 |
A Boolean number in a number field or in a calculation field that produces a Boolean result | 1 to find True values 0 to find False values | 1 finds 1 0 finds 0 |
Invalid data (fields with no numeric digits) in a number field or calculation field that produces a numeric result | ? | ? finds twelve but not 12 or twelve30 |
A date in a date field or in a calculation field that produces a date result | The date as digits, separated by a valid date separator character (such as a slash or hyphen) 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 |
Today's date in a date field or in a calculation field that produces a date result | // | // finds April 4, 2014 (when the current date is 4/4/2014) |
A time in a time field or in a calculation field that produces a time result | The time as digits, separated by colons | 12:53:09 finds 12:53:09 |
A timestamp in a timestamp field or in a calculation field that produces a timestamp | The date as digits, separated by a valid date separator character, then the time as digits, separated by colons | 3/3/2014 12:59:09 PM finds 3/3/2014 12:59:09 PM |
Invalid dates, times, timestamps, or calculated date or time results | ? | ? finds Next Tuesday or 2/33/2014 in a date field, or midnight in a time field |
Dates on a day of the week in a date or timestamp field | The day of the week 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 |
Any valid value for a date or time component in a date, time, or timestamp field | * or leave component unspecified, while specifying the other components you want to find | 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 |
Ranges of information |