There are two ways to reference dates and times in your queries:

• absolute dates/times: e.g. 31st October 2013, or 11am on 1 May 2014

• relative time periods using placeholders: e.g. %LAST_WEEK%

To avoid confusion, it’s best to avoid combining absolute and relative dates/times in one query.