(301) 947-7380
99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.

DAT Operator

Posted October 30, 2026
DAT Operator is a part of DAT Field Condition that governs the relationship between the selected field and user-provided values. Note that the operator options change based on the type (numeric, date, or text) of the chosen field.

In addition to simple DAT Operators such as: =, <>, >, <, contains, not contains, starts with, ends with, multi select, is one of, is not one of and range, you also have an option to use DAT Functional Operators.

is one of / is not one of: enter a list of values the field must match (is one of) or must not match (is not one of). Put one value per line, as you get when you paste a column from Excel, or separate the values with commas. Spaces around each value, quotes around a value, blank lines and repeated values are removed when you click Add. If a value does not fit the field, for example letters in a numeric field, the values are listed at the top of the window and the condition is added once they are corrected. These operators are available for text, numeric, date and time fields.

Note: For those operators which have an option for you to specify values, the value box lists up to 100 values from your database and multi select lists 25 at a time, so if you do not see a value you are looking for, type the start of it to narrow the list, or type it directly in the value box.

See also
·

Was this article helpful?

Your feedback goes to the team that maintains this article.

Thanks. We use this to improve the article.

Still have questions?

Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.

Open a ticket

New to PCR Educator?

If you landed here from a search and want to see what PCR Educator can do, the demo is the fastest way in. Thirty minutes, no commitment.

PCR Educator
School Operations Platform

One platform for K-12 schools, higher education, performing arts institutions, and health science programs since 1989.

PCR Educator on Capterra: 4.7 out of 5 stars
Platform
    Solutions
      Resources
        Company
          © 1989-2026 PCR Educator, Inc.Silver Spring, MD · U.S.A. · (301) 947-7380