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