OpenEMM Technical Support Forum

Hi,

We seemed to be on top of things with 5.4 and had managed to send out a couple of mailings, but having 'upgraded' to 5.5.0, target groups and mailings based on date ranges seem to be broken again - for example, I have a database of around 80000 animals with date ranges from 1999 to the current day, but if I create a target group of 'vacdate = 200805 YYYYMM' and then instruct that these records should be deleted, I am told 'o' records will be deleted - but there are hundreds within that criteria.

We have also tried to use a pre-existing target group that should mail clients with date ranges where 'vacdate' = 200808 YYYYMM or 'vacdate2' = 200808 YYYYMM - but this selects or creates a mailing list with 0 entries where there should be several thousand.

Looking into this, if I use a date range of > 20080731 and < 20080901 things seem to work OK so it looks like YYYYMM (ie no day) matching is broken.

Any thoughts?

Thanks

We are working on fixing this bug. Please follow progress here:

https://sourceforge.net/tracker/index.p ... tid=848488

Thanks Ma,

As I have posted in the bugtracker, I tried the updated .class file but no luck so far - but thanks for the quick response to this, I'm sure the problem will be fixed shortly.

Well, it worked for us on our server. Let's try an example. We create a target group "test" which holds all customers with a change date of July 2008 (change_date = '200807'). This should create in table dyn_target_tbl the entry To double-check please run the statement and verify. This statement should yield the same sequence. If not, please tell us what you got.