NI 7 days recycling
Posted: Tue Oct 01, 2024 3:06 am
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:
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')