Date variables

SAXT Reports that include Date output can be written to include conditions based on today’s date. In this way, reports can be constructed to provide relative output such as Definitions created in the last week or month, and so on. To use these variables in SAXT Query Builder or in a page file, you must use the variable in the below format for the SAXT Reporting engine to recognize the special use case.

Variable	Description
%SAXT_LASTYEAR%	This variable is replaced with today’s date minus one year.
%SAXT_LASTMONTH%	This variable is replaced with today’s date minus one month.
%SAXT_LASTWEEK%	This variable is replaced with today’s date minus one week.
%SAXT_TODAY_MINUS###%	This variable can be customized to subtract any number of days from today’s date. Replace the # characters with actual numbers to have a customizable date. Some examples are: %SAXT_TODAY_MINUS1% is within the previous day, %SAXT_TODAY_MINUS180% is today minus 180 days (which is today minus approximately six months), or %SAXT_TODAY_MINUS1825% is today minus 1825 days (which is today minus approximately five years).
%SAXT_TODAY_PLUS###%	This variable can be customized to add any number of days from today’s date. Replace the # characters with actual numbers to have a customizable date. Some examples are: %SAXT_TODAY_PLUS1% is within the next day, %SAXT_TODAY_PLUS180% is today plus 180 days (which is today plus approximately six months), or %SAXT_TODAY_PLUS1825% is today plus 1825 days (which is today plus approximately five years).