Using System Parameters in Queries

Overview

This article lists the available parameters that can be used when creating a query. The parameters typically must be contained in curly brackets. For example, the correct syntax for “last week begin date” is: {last_week_begin_date}.

If the query is saved, the values of any system parameters are recalculated when the query is run. Read more about saving queries.

Parameters

Dates

  • {Today}: returns the current date
  • {Tomorrow}: returns tomorrow’s date
  • {Yesterday}: returns yesterday’s date

Day

  • {Two_Days_Ago}: returns the date of two days ago
  • {Three_Days_Ago}: returns the date of three days ago

Week

  • {Current_Day_Of_Week}: returns the number of the current day of the week
  • {Current_Week_Begin_Date}: returns the date of this week’s beginning
  • {Current_Week_End_Date}: returns the date of this week’s end
  • {Next_Week_Begin_Date}: returns the date of next week’s beginning
  • {Next_Week_End_Date}: returns the date of next week’s end
  • {Last_Week_Begin_Date}: returns the date of last week’s beginning
  • {Last_Week_End_Date}: returns the date of last week’s end
  • {Two_Weeks_Ago}: returns the date of two weeks ago from today

Month

  • {Last_Month_Begin_Date}: returns the date of the beginning of last month
  • {Last_Month_End_Date}: returns the date of the end of last month
  • {Current_Month_Begin_Date}: returns the date of the beginning of the current month
  • {Current_Month_End_Date}: returns the date of the end of the current month

Year

  • {One_Year_Ago}: returns the date of one year ago from today
  • {Current_Year_Begin_Date}: returns the date of the first day of school for the current year
  • {Current_Year_End_Date}: returns the date of the last day of school for the current year
  • {Previous_School_Year}: returns the year that is most prior to the “current” school year

Grading Period/Terms (Semesters)

  • {Active_Grading_Period_Begin_Date}: returns the date at the beginning of the current grading period
  • {Active_Grading_Period_End_Date}: returns the date at the end of the current grading period
  • {Active_Term_Begin_Date}: returns the date of the beginning of the current term
  • {Active_Term_End_Date}: returns the date of the end of the current term

Dynamic Parameters

Time

  • {Now}: returns the current time

Person

  • {Me}: returns your id