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" <exim-users@???>
To: <exim-users@???>
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/
>
