OpenEMM Technical Support Forum

Hi!
I want to send birthday newsletter to all people younger than 27. I'm using openemm 5.5.1. But the problem is that date based target groups don't appear to work.

I created a birthdaymailing target group with following definitions:
birthdate = current_timestamp (MMDD)
and age < 27
but nobody get the birthdaymail

If I add following definition:
or email = mymailadress@xx.xx I get the birthday mail

column target_sql in the dyn_target_tbl:
cust.age < 27 AND date_format(cust.birthdate, '%m%d') = date_format(current_timestamp, '%m%d') OR lower(cust.email) = lower('mymailadress@xx.xx')

If I execute the statement SELECT * FROM `customer_2_tbl`
WHERE age <27 AND date_format( birthdate, '%m%d' ) = date_format(
CURRENT_TIMESTAMP , '%m%d' ) it shows the right persons.

I don't know where the problem is. I hope anybody can help me.

Do you have any idea? Do you need more information?
It is very important. Thank you for your help.

Is your custom field "age" of type numerical or alpha numerical?

The type of "age" is double.
e.g. values are 10,17,27,30 ...

When you select recipients with your target group in Recipients -> Overview - does this look ok?

YES.
Also the column target_sql in the dyn_target_tbl looks correct.
cust.age < 27 AND date_format(cust.birthdate, '%m%d') = date_format(current_timestamp, '%m%d') OR lower(cust.email) = lower('mymailadress@xx.xx')

We tried to replicate your problem with a target group like

date_field = current_timestamp (MMTT)
AND
num_field > 10

and it worked fine for us. Could you please recheck?

I will try it and post the result on monday.

date_field = current_timestamp (MMDD) AND
num_field = 10000

worked fine

Any other Ideas?
Where can I find the logfile with the list of the recipients.
According to the openemm-mailgun.log-File oemm creates a temporary table with all recipients, but after finishing the process oemm drops this table.