Logo
My activities

Criteria Operators

Analysis Expert uses operators to determine what data to display. The following table explains what each operator means.

Symbol

Read as

Explanation of Result

=

“equals”

Will display records where the field’s value is equal to the value specified. Note that only exact matches will be displayed.

>=

“is greater than or equal to”

Will display records where the field’s value is greater than or equal to the value specified. This operator is only available for criteria with numerical values, such as dates, quantities, amounts of money, etc.

<=

“is less than or equal to”

Will display records where the field’s value is less than or equal to the value specified. This operator is only available for criteria with numerical values.

“is greater than”

Will display records where the field’s value is greater than the value specified. This operator is only available for criteria with numerical values.

“is less than”

Will display records where the field’s value is less than the value specified. This operator is only available for criteria with numerical values.

<> 

“is not equal to”

Will display records where the field’s value is not equal to the value specified.

Like

“like”

Will display records where the value specified is contained somewhere in the selected field.

Starts with

“starts with”

Will display records where the field’s value starts with the value specified.

Ends with

“ends with”

Will display records where the field’s value ends with the value specified.

Between

“between”

Will display records where the field’s value is between the dates specified.

Not Between

“not between”

Will display records where the field’s value is not between the dates specified.

Today

“today”

Will display records where the field’s value is today’s date.

Yesterday

“yesterday”

Will display records where the field’s value is yesterday’s date.

This Week

“this week”

Will display records where the field’s value contains records from this week.

This Month

“this month”

Will display records where the field’s value contains records from this month.

This Year

“this year”

Will display records where the field’s value contains records from this year.

Last # Days

“last # days”

Will display records where the field’s value contains records from the last specified number of days. Will not display the day you are currently in.

Last # Weeks

“last # weeks”

Will display records where the field’s value contains records from the last specified number of weeks. Will not display the week you are currently in (reads as Sunday-Saturday).

Last # Months

“last # months”

Will display records where the field’s value contains records from the last specified number of months. Will not display the month you are currently in.

Last # Years

“last # years”

Will display records where the field’s value contains records from the last specified number of years. Will not display the year you are currently in.

Is Empty

“is empty”

Will display records where the field’s value is N/A. Using the operator “is empty” will lock (make uneditable) the Value field.

 

See also:

Follow
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk