Filter out (removes) rows that meet a specified date criteria.

Syntax:

RemoveDate, dateColumnName, compareOperator, tildeDelimitedDateTime

RemoveByRelativeDate, dateColumnName, compareOperator, tildeDelimitedDateTime, tildeDelimitedLagDateTime 

Parameters:

textColumnName – name of the text column

tildeDelimitedDateTime - a date/time sequence in the form of year~month~day~hour~minute 

tildeDelimitedLagDateTime - lag periods to be added to above to determine the actual dat/time to be used in the form of year~month~day~hour~minute. Negative numbers move the date/time to an earlier period.

Examples:

Removes all rows where the date column named "Date" is greater than 2006-01-02.

Removes all rows where the date column named "Date" is greater than 2006-01-01 with one day lag (2006-01-02).

Author Mode menu:

Filter -> By Specific Date 

Filter -> By Relative Date

Change History

v4.1 command changed from FilterByDate to RemoveDate