I dont want to dial 8 days old leads...

[kenneth]

hi Guys,
I dont want to dial 8 days old leads...
Is this the right query? -to be put in the filter.

entry_date > DATE_SUB(NOW(),INTERVAL 7 DAY)

thanks!

[williamconley]

1) Welcome to the Party!

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) In direct response to your question: It looks good but don't take my word for it. Test it. Have a look at the "hopper" for a list and see what the dates are for those leads, when the sort order for the campaign is set to load the oldest leads first. Then apply the filter, empty the hopper, and see if the leads that load next meet your requirement. The hopper is loaded once per minute, on the minute.

4) The later versions of Vicidial have a list expiration date feature (on the List Modify page).

Happy Hunting!