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=S1 | Required 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.
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.