Problem with Target Based emails

[hari]

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.

[hari]

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

[maschoff]

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

[hari]

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

[maschoff]

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

[hari]

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')

[maschoff]

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?

[hari]

I will try it and post the result on monday.

[hari]

date_field = current_timestamp (MMDD) AND
num_field = 10000

worked fine

[hari]

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.