Using date field in target group definition fails

[greetchen]

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

[maschoff]

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

[greetchen]

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

[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.

[maschoff]

Ok, we will look into that!

[maschoff]

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

[greetchen]

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