DateFilter Command

Use the DateFilter command in a Logic Template to filter out records that by comparing date-time values to a specified criteria.

When dealing with large amounts of data it is often more efficient to use a timeline index to narrow the search. The DateFilter command can then be used to fine tune the result set.

To execute a Date-Time Filter request, use the DateFilter command with three or four arguments:

DateFilter( op, dtm, test ); or DateFilter( op, dtm, test, flag );

DateFilter Arguments

Argument

Description

op

The operator.

dtm

The name of the date-time data field to be tested.

test

The name of the HTML variable containing the date and/or time to test against.

flag

indicate ( drop or keep ) special processing for records with a value of zero for dtm.

Access the DateFilter Dialog Box by selecting Date-Time->Comparison menu item under the Filtering category of the Logic Template editor command menu.

Examples

Command

Description

DateFilter( EXACT_MATCH, EventDate, TestDate );

Pass records containing, in the field named "EventDate", a date and time value that is equal to the date and time value stored in HTML variable "TestDate".

DateFilter( EXACT_MATCH, EventDate, TestDate, keep);

Pass records containing, in the field named "EventDate", either nothing or a date and time value that is equal to the date and time value stored in the HTML variable "TestDate".

DateFilter( PRIOR_EVENTS, EventDate, TestDate, keep);

Pass records containing, in the field named "EventDate", either nothing or a date and time value that occurs prior to the date and time value stored in the HTML variable "TestDate".

DateFilter( FUTURE_EVENTS, EventDate, TestDate );

Pass records containing, in the field named "EventDate", a date and time value that occurs on or after the date and time value stored in the HTML variable "TestDate".