Skip to main content

Date and Time Operations

in DPQL Reference
Authors list
Ippubblikat: Mar 16, 2017|Aġġornat: Nov 3, 2022

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.

UtliMhux utli

2 ta' 2 nies li sabu din il-paġna utli

Pages in Date and Time Operations

Absolute Dates and Times
Authors list
Ippubblikat: May 22, 2018
Aġġornat: Nov 3, 2022
Relative Dates with Placeholders
Authors list
Ippubblikat: Mar 16, 2017
Aġġornat: Nov 3, 2022
Dates from Custom Fields
Authors list
Ippubblikat: Mar 16, 2017
Aġġornat: Nov 3, 2022
Finding an Interval between Two Date/Times
Authors list
Ippubblikat: Mar 16, 2017
Aġġornat: Nov 3, 2022
List of Date Placeholders
Authors list
Ippubblikat: Apr 16, 2019
Aġġornat: Nov 3, 2022
next pageList of Functions
previous pageArchived Status

Please log in or register to submit a comment.