Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT Functional Operator
DAT Functional Operator
DAT Functional Operator
DAT
Functional Operator is a version of
DAT Operator
that uses system-calculated values for conditions as opposed to user-specified values as in the case with simple
DAT Operator
s. When you select one of the
DAT
Functional Operators, you won't need to specify the operator values directly, as these are calculated by the system. The list of available
DAT
Functional Operators may change depending on the chosen table, field and data type.
- Academic Year calculates the academic year based on the current School Year in
School Info
.
- Academic Year (Admissions) calculates the academic year based on the Admissions Year in
School Info
.
- Fiscal Year (Finance) calculates the fiscal year based on the fiscal years set up in Finance.
- Fiscal Year (Development) calculates the fiscal year based on Security > Maintenance >
Application Setup
page's Development Fiscal Date field.
-
School Division
calculates the school id to use based on your current school division. This allows the same
DAT Query
to be used in multiple divisions, but still only show division specific information. You would generally only use this for fields involving a school id such as course school id or department school id.
- Is Blank (Date) checks if no value is
specified.
- The Next (Date) checks if the specified date field's value occurs in the next minutes / hours / days / months / quarters / years as specified by you.
Note
: The Next is intended to search based on a statement like “I want a list of all the emails scheduled to go out in The Next 10 days.” The search condition is properly described as <= 10 days in the future from today.
Note
: The Next is intended to be future looking. To have the condition apply to a date in the past, use a negative value.
Example
: The Next -10 Days means 10 in the past going backwards.
Note
: Date comparisons are based on school timezone information if it is specified in the application settings, otherwise server time is used.
- The Last (Date) checks if the specified date field's value occurs in the previous minutes / hours / days / months / quarters / years as specified by you.
Note
: The Last is intended to search based on a statement like “I want a list of all the emails sent out in The Last 5 days.” The search condition is properly described as >= 5 days ago from today.
Note
: The Last is intended to be past looking. To have the condition apply to a date in the future, use a negative value.
Example
: The Last -5 Days means 5 days in the future going forward.
Note
: Date comparisons are based on school timezone information if it is specified in the application settings, otherwise server time is used.
Note
: The Next and The Last are able to work together to define a range of time. Example: "I want a list of all emails in The Last 5 days and The Next 5 days." This defines a range of time from 5 days ago through 5 days from now.
- Today always uses today's date when you access the query.
Note
: Date comparisons are based on school timezone information if it is specified in the application settings, otherwise server time is used.
-
Other
Field allows you to do a comparison with a field appearing in the current table, or with a previous table further up the join conditions.
See also
Application Setup
School Division
DAT Operator
School Info
DAT Query
Course
User
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.