docdate

Purpose

Finds documents from a specified date range. The function requires date and time column to be set in Index node properties.

Syntax

docdate([restriction type,date1,[date2]])

Arguments

The first optional parameter restriction type allows to set target date range. Accepts one of the following values:

  • lt/less/<:/<

  • le/less or equal/<=:/<=

  • gt/greater/>:/>

  • ge/greater or equal/>=:/>=

  • eq/equal/=:/=

  • ne/not equal/!=:/!=

  • bt/between/():/()

  • be/between or equal/[]:/[]

  • lo/left-open/(]:/(]

  • ro/right-open/[):/[)

If restriction type consists of mathematical symbols (>, (), !=, etc.), it should be enclosed in quotes. The second and optionally the third parameter specify required date range. Dates should be in "mm/dd/yyyy" format.

Returned Value

Documents matching the query.

Examples

docdate() matches documents of any date;

not docdate() matches documents with no date;

docdate(less, "02/25/2002") = docdate(lt, "02/25/2002") = docdate("<", "02/25/2002") matches documents before 25 February 2002;

docdate("02/25/2002") = docdate(eq, "02/25/2002") = docdate("=", "02/25/2002") matches documents of 25 February 2002;

docdate(be, "02/25/2002", "05/25/2003") = docdate("[]", "02/25/2002", "05/25/2003") matches documents between 25 February 2002 and 25 February 2003.