@@ -, +, @@ --- C4/Letters.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) --- a/C4/Letters.pm +++ a/C4/Letters.pm @@ -1004,9 +1004,9 @@ sub _is_duplicate { WHERE message_transport_type = ? AND borrowernumber = ? AND letter_code = ? - AND CAST(time_queued AS date) = CAST(? AS date) + AND CAST(time_queued AS date) = CAST(NOW() AS date) AND status="sent" - |, {}, $message->{message_transport_type}, $message->{borrowernumber}, $message->{letter_code}, $message->{time_queued} ); + |, {}, $message->{message_transport_type}, $message->{borrowernumber}, $message->{letter_code} ); return $count; } --