Another way to do this uses a formula called mailto:%7b@NextDate - {@NextDate } that looks something like this:

Numbervar yy;
Numbervar mm;
yy := year(CurrentDate);
mm := month(CurrentDate);
if mm = 12 then mm := 1 else mm := mm + 1;
if mm = 12 then yy = yy + 1;
Date(yy, mm, 1)

You then add the following to the selection formula:  {table.DatePurchased} = mailto:%7b@NextDate - {@NextDate }

 

The problem with this method is that it will probably bring all of the records to the workstation and then do its filtering.  If you're using Access or another file-based database, this is not an issue, but if you're using a client-server database (MS SQL, Oracle, etc.) then it's MUCH more efficient to use the Command.

 

-Dell