Hi everyone,
I'm crap at english, sorry.
I would like to create a dynamic recipient list with DirectMail. The list
contains users who have their 'premium service' closing in the month.
On DirectMail, I chose "special querry" and then I create my query with "WHERE endtime
>= today AND endtime <= today+30"
Here is the result :
SELECT uid,pid,deleted FROM fe_users WHERE ( endtime >= 1380797021 AND endtime <= 1383389026) AND fe_users.deleted=0
I would like to have something more like this :
SELECT uid,pid,deleted FROM fe_users WHERE ( endtime >= today AND endtime <= today+30) AND fe_users.deleted=0
Having "today" and "today+30" would be very dynamic, everyday the timetsamp
would change and it would be great to send mails without having to refresh the recipient list every
day.
Thanks for your help.
Cordialement,
Salander
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english