Choose a comparison operator.
(The list of operators depends on the type of field.)
Specify a value to compare to.
For an enumeration field like status, which has a list of defined values,
you can choose the in operator, and select multiple values from the list.
The kind of comparisions you can do depends on the field type:
Date fields
Specify a date range (from- and to- dates, or specify one of the predefined Date functions:
This Month or This Week
Today, Tomorrow, or Yesterday
Last Month/Week/7 days
Next Month/Week/7 days
Previous 12 months
Current/Next/Previous Quarter (and combinations like Current & Previous)
Current/Next/Previous Year (and combinations)
(The dates that match those functions depend on the current date, so each day
you run the report you get a different set of records.)
Time fields Similarly, using the Time functions.
Enumeration and Checklist fields (a list of choices the user picks from)
Possible operators are Equals (specify a single value) or In (specify a comma-separated series of values. Note that values you specify are the internal values stored in the system to reflect the user's choices--not the external labels that users see when making their choice.
Number, Number with Decimal, Currency, Number Formula, Rollup
Possible operators are Equals, Not Equal to, Less than, Greater than, Less than or Equal to, Greater than or Equal to. Compare to a numeric value.
Text , Phone, Email, Autonumber, Text Formula
Operators are Equals, Contains, Starts with, Ends With, Is Empty.
For the value, specify the text to compare to.|
Boolean
Compare to 'Yes' or 'No'.
User, Role
Select one or more values to compare to, the same way you select values anywhere else the fields appear: Start typing to narrow the list of possibilities, and click on the entry you want. Use Equals to compare against one value, In to compare against multiple possible values.
Also: Logged In User is one of the possible values in a User field.
Image, File, Document List
These fields can't be used for comparisons.