User manual

46 | Using databases
Finding numbers, dates, times, and timestamps
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. See
“About choosing a field type”
on page 82.
Important To avoid confusion when working with dates, always use four-digit
years. For more information, see the Help topic “Conversion of dates with two-
digit years.”
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
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
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)
3/3/2010 finds 3/3/2010,
March 3, 2010, and 3-3-2010
Today’s date in a date field
or in a calculation field that
produces a date result
// // finds April 4, 2010 (when
the current date is 4/4/2010)
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
result
The date as digits, separated
by a valid date separator
character, then the time as
digits, separated by colons
3/3/2010 12:53:09
PM finds 3/3/2010 12:53:09 PM
Invalid dates, times,
timestamps, or calculated
date or time results
? ? finds:
Next Tuesday or 2/33/2010 in a
date field, or midnight in a
time field
φμπ10_υσερσ_γυιδε.βοοκ Παγε 46 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ