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.
To find numbers, dates, times, and timestamps:
- Start a find request.
- Click Perform Find in the status toolbar.
To find |
Type this in the field |
Examples |
A number |
The number |
|
One or more numeric digits |
A # character for each digit |
|
A Boolean number |
|
|
Invalid data (fields with no numeric digits) |
? |
|
A date |
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 |
|
Today's date |
|
|
A time |
The time as digits, separated by colons |
|
A timestamp |
The date as digits, separated by a valid date separator character, then the time as digits, separated by colons |
|
Invalid dates, times, or timestamps |
? |
|
Dates on a day of the week |
The day of the week Note Full or short day names (for example, Friday or Fri) are acceptable in day of week searches |
|
Any valid value for a date or time component in a date, time, or timestamp |
* or leave component unspecified, while specifying the other components you want to find |
|
Ranges of information |
Notes
- When you perform day of the week searches on systems set to a language other than English, you may use English day names and abbreviations if you wish. The English names are supported in all system formats. See Opening files with different system formats.
- When you perform day of the week searches, the first day of the week depends on your system settings. Sunday is the first day of the week in English, Japanese, and Korean.