Selecting Members by Date

You can extract attributes data for a specific date, for a period before a specific date, or for a period after a specific date using the <TODATE command. For example, you can extract information on all products that were introduced on December 10, 1996, before December 10, 1996, or after December 10, 1996. The <TODATE command must be used within the <WITHATTR command. For example, the following format returns data on all products that were introduced on December 10, 1996.

<WITHATTR ("Intro Date", "=", <TODATE ("mm-dd-yyyy", "12-10-1996")

The following format returns data on all products that were introduced before December 10, 1996.

<WITHATTR ("Intro Date", "<", <TODATE ("mm-dd-yyyy", "12-10-1996")

The following format returns data on all products that were introduced after December 10, 1996.

<WITHATTR ("Intro Date", ">", <TODATE ("mm-dd-yyyy", "12-10-1996")

Note:

The types of date format supported are mm-dd-yyyy or dd-mm-yyyy. The date must be between January 1, 1970 and January 1, 2038 (inclusive).