Thursday, May 28, 2009

GoldMine: Recent Contacts

A Goldmine client asked: How can I find out which contacts were added this month?

That depends on your database type. If you are using a SQL database, you would enter this query in your SQL Query pane:

select company, contact, createon, phone1, source, key1
from contact1
where year(createon) = year(getdate()) and
month(createon) = month(getdate())

If you are using the DBase database, you need to enter the following query:

select company, contact, createon, phone1, source, key1
from contact1
where createon >= '5/1/2009' and createon <= '5/30/2009'

The DBase version would need to be modified each month.

No comments: