
Originally Posted by
lukelloyd
Hi Cord
Have you managed to work out why this isnt working for me yet please?
sorry, was busy. But lets have a look:
The query to select the customers by date looks like this
PHP Code:
(...) " and ci.customers_info_date_account_created <= '" . $date_passed . "'
and ci.customers_info_date_account_created > '" . $date_skip . "' ";
while the date is calculated
PHP Code:
$date_passed = dbdate(MAILBEEZ_NOPURCHASE_PASSED_DAYS);
using
PHP Code:
function dbdate($day) {
$rawtime = strtotime("-".$day." days");
$ndate = date("Ymd", $rawtime);
return $ndate;
}
so with -1 (results into "now" + 1) $date_passed should be in any case bigger than account_created (when run daily)
Are you sure it doesn't work? or did you already run the module and you do not have new customers to catch?
cheers
cord
Bookmarks