Date and time operations

DPQL Reference

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.

Published: 16/03/2017

Last updated: 16/03/2017