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". |