Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Operators for Advanced Searches

When you apply advanced settings to a search, you can use a number of comparative operators, such as "equals," "less than," "greater than," and "starts with."

You use different operators with different data types: string, date, number, memo, check box, and employee. The operators that display depend on the type of field that is selected.

Operator Data Type Description
equals string; date; number; employee Finds exact match.
  • The user can select only one value from a list for a drop-down or lookup.
  • The user can select only one date from a calendar or type one date using the keyboard for a date field.
  • For other fields, the user can enter text and the system must find an exact match on that text.
does not equal string; date; number; employee Finds records that are not an exact match.
in list string; date;employee Default for drop-down list and radio buttons.
  • Select many values from a list for a drop-down, lookup, or radio button.
  • You can select many dates from a calendar or type in a date using the keyboard.
  • You can enter multiple text phrases in the search list separated by semicolons for character and memo fields. The system will search for a record that has an exact match on one of those phrases.
is not in list Searches for records that do not have the items in the list.
starts with string Find all records that start with certain characters.
greater than date; number
  • Default for number and currency fields.
  • Find all records that have a number, date or text (by ascending sort order) greater than the entered number, date or text.
less than date; number
  • Find all records that have a number, date or text (by ascending sort order) less than the entered number, date or text.
contains memo
  • Default for character and memo fields
  • Find all records that have the entered text somewhere in the field.
does not contain memo
empty memo Find all records that have nothing in this field. The search list is disabled or not available when this operator is selected.
not empty memo Find all records that have something populated in this field. The search list is disabled or not available when this operator is selected
checked checkbox
not checked checkbox
starts with employee
greater than or equal to Find all records that have a number, date or text (by ascending sort order) greater than or equal to the entered number, date or text.
less than or equal to

:

Find all records that have a number, date or text (by ascending sort order) less than or equal to the entered number, date or text.

between Enter exactly two values in the search list for this operator. Finds all records that have a value between the two values entered.
is me employee name; employee number Search for records that belong to you.
is not me employee name; employee number Search for records that do not belong to you.
is mine organizations Find all records where the user's employee home organization is associated in the selected organization lookup
is not mine organizations Find all records where the user's employee home organization is not associated
is active company Multicompany only; Company lookups only The search list is disabled and the system searches for records that are in the same company as the user is currently in.
is home company Multicompany only; Company lookups only The search list is disabled and the system searches for records that are in the same company as the home company for the employee of this user
is not home company Multicompany only; Company lookups only The search list is disabled and the system searches for records that are in a different company than the home company for the employee of this user.
checked checkboxes only Default is selected; search list is disabled or not available when this operator is selected.
not checked Search list is disabled or not available when this operator is selected
is today date Finds records where the date is the same as today's date. The search list is disabled or not available when this operator is selected.
month is date Finds records where the date is in the selected month. The search list is a drop-down with all the months (January - December) listed. The user can select multiple months. Usually used in conjunction with Year is.
quarter is date Finds records where the date is in the selected quarter. The search list is a drop-down with all the quarters (1st - 4th) listed. The user can select multiple quarters. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. Usually used in conjunction with Year is.
year is date Finds records where the date is in the selected year. The search list is a number field where the user must enter 4 digits.
this week date Finds records where the date is in this week (defined from Sun - Sat). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use This week, it will search for dates between Sun 3/6 - Sat 3/12.
this month date Finds records where the date is in this month (defined from the 1st - last date of the current month). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use This month, it will search for dates between 3/1 - 3/31.
last month date Finds records where the date is in last month (defined from the 1st - last date of the previous month). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use Last month, it will search for dates between 2/1 - 2/29.
next month date Finds records where the date is in the next month (defined from the 1st - last date of the next month). The search list is disabled or not available when this operator is selected. For example, if today is Wed 3/9 and I use Next month, it will search for dates between 4/1 - 4/30.
this quarter date Finds records where the date is in this quarter. The search list is disabled or not available when this operator is selected. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. If I search on 3/9 and I use This quarter, it will search for dates between 1/1/2021 - 3/31/2021.
last quarter date Finds records where the date is in last quarter. The search list is disabled or not available when this operator is selected. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. If I search on 3/9 and I use Last quarter, it will search for dates between 10/1/2020 - 12/31/2020.
next quarter date Finds records where the date is in the next quarter. The search list is disabled or not available when this operator is selected. The quarters are Jan 1 - Mar 31, Apr 1 - Jun 30, Jul 1 - Sep 30, Oct 1 - Dec 31. If I search on 3/9 and I use Next quarter, it will search for dates between 4/1/2021 - 6/30/2021.
last days date Finds records where the date was in the number of entered days. The user must enter a number. For example, if today is 3/9 and I enter Last days 3, it will find all records with a date between 3/6 - 3/9 (today is counted plus the previous 3 days).
next days date Finds records where the date will occur in the number of entered days. The user must enter a number. For example, if today is 3/9 and I enter Next days 3, it will find all records with a date between 3/9 - 3/12 (today is counted plus the next 3 days).