OK,
no matter if it is a mysql or a standard file, it is a variable from exim
which returns the current time(format date) and can no matter if it is a
mysql or a standard file, it is a variable from exim which returns the
current date (date format) and can check if it is smaller or larger than the
given one
regards
----- Original Message -----
From: "Jeremy Harris via Exim-users" <[email protected]>
To: <[email protected]>
Sent: Tuesday, March 3, 2020 2:55 PM
Subject: Re: [exim] Vacation rule frm to date
On 03/03/2020 13:36, Sławomir Dworaczek via Exim-users wrote:
uservacation:
driver = accept
domains = ${lookup mysql{SELECT domains.fqdn AS domain FROM
domains,mailboxes,vacations WHERE \
vacations.active=1 AND \
vacations.mailbox_id=mailboxes.id AND \
mailboxes.active=1 AND \
mailboxes.local_part='${quote_mysql:$local_part}' AND
\
mailboxes.domain_id=domains.id AND \
domains.active=1 AND \
domains.fqdn='${quote_mysql:$domain}'}}
it's possible add start date and end date autoreply ?
eg. if current date > startdate and current date < stopdate
If you're wanting to do that as part of the mysql
lookup (which seems reasonable) then you're asking
in the wrong place; it's a mysql syntax problem.
--
Cheers,
Jeremy
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
