Skip to main content
Skip table of contents

Date Information DATs

Date Information (PowerSchool SIS Version 20.11.1.0+)

The Date Information DAT extracts various date information and allows for advanced formatting.

Format: ~(date.information;type=[type];schoolid=[schoolid];yearid=[yearid];termabbr=[termabbr];offset=[offset];dateformat=[dateformat])

Parameter

Usage and Examples

Description

Type

~(date.information;type=today

~(date.information;type=current_term_start

~(date.information;type=current_term_end

~(date.information;type=current_year_start

~(date.information;type=current_year_end

~(date.information;type=term_start

~(date.information;type=term_end

Identifies the type of date information to return. With the exception of today, dates are based on cached values from the Terms table.

SchoolId

~(date.information;schoolid=100

Optional - Defaults to the currently selected school. The Terms.SchoolID (Schools.School_Number) to evaluate.

YearId

~(date.information;yearid=29

Optional - Defaults to the currently selected year. The Terms.ID where YearID * 100 to evaluate.

Termabbr~(date.information;termabbr=S1Required when Type is term_start or term_end. Determines the Terms record to be evaluated based on the Terms.Abbreviation.
Offset~(date.information;offset=1

Determines the offset to apply to the date returned. Accepts a positive or negative number. For example:

Tomorrow: ~(date.information;type=today;offset=1)

Yesterday: ~(date.information;type=today;offset=-1)

DateFormat

~(date.information;dateformat=MM-dd-yyyy

Determines the date format for the result. These are case sensitive and based on the Java DateTimeFormatter symbols.

  • MM - Month
  • dd - Day
  • yyyy - Year

Defaults to the current users Locale date format.

Example #1:

~(date.information;type=current_term_start;dateformat=MM-dd-yyyy)

This example returns the current terms start date in a MM-dd-yyyy format.

Example #2:

~(date.information;type=term_end;termabbr=S1;dateformat=MM-dd-yyyy)

This example returns the last day of the Terms record for the current school and year where the term abbreviation is S1 in a MM-dd-yyyy format.

Example #3:

~(date.information;type=term_end;termabbr=S1;yearid=29;dateformat=MM-dd-yyyy)

This example returns the last day of the Terms record for the current school and the 2019-2020 school year where the term abbreviation is S1 in a MM-dd-yyyy format.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.