99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.
Posted November 09, 2018
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 Operators. When you select one of the DAT Functional Operators, you will not 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.
Update

Streamlined Selector and Widget Configuration

1 min read · Updated April 26, 2026

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 can do, the demo is the fastest way in. Thirty minutes, no commitment.

Book a demo