Search |
Select by making
comparisons against the desired extraction from the datetime field
specified in the Use parameter,
using the given Condition,
compared to the given value or values, which can be
values from a field, a specified value, or the result of an expression
that evaluates to a numeric value or to a datetime value depending
on the data type of the extraction specified in the Use
parameter.
Use options:
- date and time -
Use the full datetime values in the source field.
- date without time -
Use the datetime values in the source field but
setting all time portions of the data time value to zero.
For example, the date without time result
for 12/25/2016 13:43:53 would be 12/25/2016 0:00:00.
- day - Use
the day of the month number of the datetime values
in the source field. For example,
the day of the month number for a datetime value
of 12/25/2016 13:43:53 would be 25.
- hour - Use
the hour of the day number, using 24 hour format, of the datetime
values in the source field. For example,
the hour of the day number for 12/25/2016 13:43:53 would be
13.
- millisecond -
Use the millisecond number of the datetime values
in the source field. Many data sets do not bother
recording greater time detail than seconds, so the millisecond
number of datetime values is often zero.
- minute - Use
the minute of the hour number of the datetime
values in the source field. For example,
the minute of the hour number for 12/25/2016 13:43:53 would
be 43.
- month - Use
the month of the year number of the datetime
values in the source field. For example,
the month of the year number for 12/25/2016 13:43:53 would
be 12.
- second - Use
the second of the minute number of the datetime
values in the source field. For example,
the second of the minute number for 12/25/2016 13:43:53 would
be 53.
- week - Use
the computed week of the year number of the datetime
values in the source field. Choosing the week option will open a
Week start parameter
box allowing specification of the day of the week (Sunday,
Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday)
on which a week is considered to begin. Choosing a different
Week start day will
often change the computed week of the year. For
example, 12/25/2016 13:43:53 falls on a Sunday. The
week of the year number for 12/25/2016 13:43:53 using a Week start day of Sunday would be 53.
Using a Week
start day of Monday for that same datetime
value would result in a week of the year number of 52.
- week day -
Use the computed day of the week number, from 1
to 7, of the datetime values
in the source field. Choosing the week
day option will open a Week
start parameter box allowing specification of the day
of the week (Sunday, Monday, Tuesday, Wednesday, Thursday,
Friday, or Saturday) on which a week is considered to begin.
Choosing a different Week
start day will often change the computed day of the
week number. For example, 12/25/2016 13:43:53 falls
on a Sunday. The day of the week number for 12/25/2016
13:43:53 using a Week start
day of Sunday
would be 1. Using a Week start day of Monday
for that same datetime value would result in a day of the
week number of 7.
- year - Use
the year number of the datetime values in the
source field. For example, the year
number for 12/25/2016 13:43:53 would be 2016.
- year day -
Use the computed day of the year number, from 1
to 365, of the datetime values in
the source field. For example, the day of the
year number for 12/25/2016 13:43:53 would be 360.
Condition options:
- between - Select
records with values between the specified At
least and At
most values, inclusive.
- equal (=) - Select
records with values equal to the specified value.
- greater (>)
- Select records with values greater than the specified value.
- greater or equal (>=)
- Select records with values greater than or equal to the
specified value.
- less (<) - Select
records with values less than the specified value.
- less or equal (<=)
- Select records with values less than or equal to the specified
value.
- not equal (<>)
- Select records with values not equal to the specified value.
If we would like to select records that are logical NOT variations
of the above, for example not
between, select on the basis of one of the above and press
Ctrl-I or Edit
- Select Inverse to invert the selection. Selecting
using between and
then pressing Ctrl-I
is the equivalent of "not between" the given values.
|
Statistic |
Selects records
based on how large or small their values are relative to other
values in the table:
- maximum - selects
records with the maximum value,
- minimum - selects
records with the minimum value,
- median - selects
records with the median value,
- top - selects the
specified number of records with the largest values,
- bottom - selects
the specified number of records with the smallest values,
- top percent - selects
records with values larger than the specified percentile,
with an option to include or exclude the bounding percentage.
- bottom percent
- selects records with values smaller than the specified
percentile, with an option to include or exclude the bounding
percentage.
Other options:
- Ignore
time - Ignore time when comparing values. Compare only
dates. Checked by default.
|