NI 7 days recycling

[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')

[mflorell]

Code: Select all

( ( (status='NI') and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -7 DAY),' ',CURTIME()) ) ) or (status != 'NI') )

[Cyberwolf2]

thank you, just applied