Page 1 of 1

NI 7 days recycling

PostPosted: Tue Oct 01, 2024 3:06 am
by Cyberwolf2
I'm trying to recycle leads for NI, but only if it's passed 7 days. How do I get this to work?

So far I have this and it isn't filtering the right way:

Do not call leads with NI and last call of 7 days or less:
Code: Select all
not (last_local_call_time > CURDATE() - interval 7 day and status = 'NI')

Re: NI 7 days recycling

PostPosted: Tue Oct 01, 2024 7:35 am
by mflorell
Code: Select all
( ( (status='NI') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -7 DAY),' ',CURTIME()) ) ) or (status != 'NI') )

Re: NI 7 days recycling

PostPosted: Wed Oct 02, 2024 12:10 pm
by Cyberwolf2
thank you, just applied