Rebill Projection Report

Hey,

I am looking for some help on how to query for a report that shows projected rebills for the next 30 days (assuming nobody cancels). Here is what I have right now.

$date_today = date("Y-m-d");
$date_30 = date('Y-m-d', strtotime($date_today) + 3600 * 24 * 30);
$string = "SELECT count(*) AS num_rebills, sum(amount) AS value_rebills, expire_date FROM amember_payments WHERE expire_date BETWEEN '$date_today' AND '$date_30' and data NOT LIKE '%cancel%' GROUP BY expire_date";

However, if somebody signed up for a $4.95 trial & rebills at $19.95, this report will be inaccurate. Any help on this would be greatly appreciated. What query should I use?

Kevin

Kevin,

Did you ever get an answer to this? I think it's a useful feature too.

Jim