OpenEMM Technical Support Forum

Hi,
I am quite new with open emm, using version 6.1. I would like to send out a mailing to a date-based target group (ideal would be creation_date or change_date but I am also open to creating and additional date field as reference).

However, when I set up a target group using change_date = sysdate (or current_timestamp - I tried both) I do not get any recipient returned.

Same happens in the recipient search - no result found when searching for change_date = sysdate or current_timestamp. I am sure there is data, when I search with change_date = 20110111 I get recipients returned (same thing with all other date fields).

I do not think my system date is set wrong, when creating a user he gets a correct creation date. Can anybody help? According to the user guide this should be so easy...

Thanks
greetchen

Could you describe a specific example we can check and reproduce?

Sure. I even use two options in the example.
Have defined a custom field LWO-date with data type= date.

Create new recipient manually with name, first name, email address and LWO date = 10 Jan 2011
Save
Profile Data displays as follows:
Creation_date = 10 Jan 2011
Change_date = 10 Jan 2011
LWO_date = 10 Jan 2011

Go to Recipient Overview -- Search.
Enter Search criteria:
a) creation_date = 20110110 - find 3 recipients, among them my test candidate
b) same result with change_date and LWO_date

c) creation_date = sysdate : Nothing found to display
d) change_date = sysdate: Nothing found to display
e) LWO_date = sysdate Nothing found..
f) creation_date = current_timestamp Nothing found ... etc.

hope that helps. thanks for the quick reply
greetchen

By the way - I just checked the same thing on the public demo version on http://demo.openemm.org:8080 and found the same behavior there.

So my first assumption that something with my database settings could be wrong seems not to be the issue.

Ok, we will look into that!

OK, I had a look at the user manual, page 67 ff: Please use now() instead of sysdate or timestamp and try again (sysdate is used by Oracle).

I should really have had a thorough look into that manual (instead of reading books and blogs...).
Thank you so much, I am really happy that I got this work now !!!
Greetchen