(Still) Can't get Target Based emails to work

doubledutch · Post by **doubledutch** » Fri Oct 03, 2008 4:53 pm

Hi, I'm still struggling in getting this to work using mysql. It must be me being very stuppid somewhere. The problem is that date based target groups don't appear to work.

From looking at the database it appears to me that the content of the database field:

dyn_target_tbl.target_sql

is used to create the target group. I edit that and put in there:

date_format(cust.creation_date, '%Y-%m-%d') = current_date

(Note the '-' which is the way mysql reports that field) a mysql query on the customer_1_tbl returns the relevant records but when I try to get the statistics for that target group on my entire recipient database it doesn't return any records.

What am I doing wrong? Any help would be greatly appreciated.

Thanks

Leon

Post by **maschoff** » Fri Oct 03, 2008 6:59 pm

You should use the expression

creation_date = current_timestamp

doubledutch · Post by **doubledutch** » Sat Oct 04, 2008 10:53 am

Thanks ma and I tried that but when I do that and look for press the statistics button the result is zero which may be valid because at the exact time I press "statistics" I guess no-one has a record with

creation_date = current_timestamp

So how does that logic work? When is this check made?

Post by **maschoff** » Sat Oct 04, 2008 1:52 pm

This was just a corrected version of your example. We use ist for birthday mails (you need a data field with the birthday, of course) like

birthday = current_timestamp

As comparison pattern you should select MMDD without year. Hour, minute and second are never considered.