As of July 12, 2021, this "Learn Veracross" site has been deprecated. It will remain live through December 2022, but will no longer be updated. All knowledge content has moved to the new Veracross Community. Please update your bookmarks.
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