Using System Parameters in Queries

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.

Here is the new version of this article in the Veracross Community.

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