There are a couple of ways to do this. What database are you using? If your database allows it, you could replace your tables with a command and use the current date to determine the first of the next month in SQL in the Where clause. This will be the most efficient way to do this.
Another way to do this uses a formula called
{@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} =
{@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
IP Logged
