Queries using keywords

You can use keywords relative to time in query expressions.
Table 1. Valid keywords
Keyword Description
%today_begin Beginning today, 00:00:00
%today_end End of today, 23:59:59
%this_week_begin Beginning of this week, 00:00:00
%this_week_end End of this week, 23:59:59
%last_week_begin Beginning of last week, 00:00:00. See Note 1.
%last_week_end End of last week, 23:59:59. See Note 1.
%this_month_begin Beginning of this month, 00:00:00
%this_month_end End of this month, 23:59:59
%last_month_begin Beginning of last month, 00:00:00
%last_month_end End of last month, 23:59:59
%this_year_begin 1 Jan this year, 00:00:00
%this_year_end 31 Dec this year, 23:59:59
%today_minus<N>days Today minus <N> days, 00:00:00
%today_plus<N>days Today plus <N> days, 00:00:00
%today_minus<N>weeks Today minus <N> weeks, 00:00:00
%today_plus<N>weeks Today plus <N> weeks, 00:00:00
%today_minus<N>months Today minus <N> months, 00:00:00. See Note 2.
%today_plus<N>months Today plus <N> months, 00:00:00. See Note 2.
%today_minus<N>years Today minus <N> years, 00:00:00. See Note 3.
%today_plus<N>years Today plus <N> years, 00:00:00. See Note 3.
Note: The first day of the week is Sunday by default. Set the model attribute start_day_of_week to change this default. A value of 1 means Monday, 2 Tuesday, and so on.

When subtracting or adding months, if the current day of the month is greater than the number of days in the resultant month, the effective date is the last day of that month. In both cases, time starts at 00:00:00. For example, if today were 31 May 2008, then %today_plus1month would be 30 June 2008, 00:00:00.

When subtracting or adding years, if the current day of the month is greater than the number of days in that month in the resultant year, the effective date is the last day of the month. For example, if today were 29 May 2008, then %today_plus1years gives 28 May 2009, 00:00:00.

Example


Feedback