List of date placeholders

Date and time operations
Placeholder Description
%EVER% A range covering any date.
%LAST_WEEK% A range covering the entirety of the previous week,based on a new week starting on a Monday.For example, if today is Wednesday the 12th,this will match Monday the 3rd to Sunday the 9th.
%LAST_MONTH%% A range covering the entirety of the previous month.For example, if today is any day in September 2012,this placeholder will match all of August 2012.
%LAST_YEAR% A range covering the entirety of the previous year.For example, if today is any day in 2012,this placeholder will match all of 2011.
%PAST_HOUR% A range covering the hour priorto the time when the report is run.
%PAST_12_HOURS% A range covering the 12 hours prior to the time when the report is run.
%PAST_24_HOURS% A range covering from exactly 24 hours agountil when the report is run.
%PAST_7_DAYS% A range covering the 7 full days priorto the day when the report is run.
%PAST_30_DAYS% A range covering the 30 full days priorto the day when the report is run.
%PAST_6_MONTHS% A range covering the 6 months priorto the day when the report is run.
%PAST_12_MONTHS% A range covering the 12 months priorto the day when the report is run.
%THIS_WEEK% A range covering the entirety of the current week,from 00:00 on the first day until 23:59 on the last day.Weeks are assumed to start on Monday and end on Sunday.
%THIS_MONTH% A range covering the entirety of the current month,from 00:00 on the first day until 23:59 on the last day.
%THIS_YEAR% A range covering all of the current calendar yearfrom 00:00 on the first day until 23:59 on the last day.
%TODAY% A range covering the entirety of the current day.
%TOMORROW% A range covering the entirety of the next day.
%YESTERDAY% A range covering the entirety of the previous day.

Remember, placeholders use your timezone, as set in your agent account Preferences.

If you have agents in different timezones, they can get different results from queries that use date placeholders. The meaning of %TODAY% is defined by the timezone of the agent who’s running the query.

Published: 16/04/2019

Last updated: 16/04/2019