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 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

Schedule Demo

Please, make sure that all required fields (marked with *) are completed.
    School Name *
    Relation to School *
    select
    Last Name *
    Your First Name *
    Your Email *
    Your Phone # *
    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.