How to Quickly Find All Contacts Created this Month

Here’s a handy SQL Query to find all contacts created this month:

To use this, from GoldMine’s main menu choose Lookup | SQL Queries then Copy & Paste the above in the top section then click Query.  If you are using GoldMine Premium Edition then Tools | Filters & Groups and then the SQL Query tab.

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

Great to ensure the cleanliness of the data entered this month.

This will only work with SQL based systems since we’re using the getdate() function to determine the current date. If you’re using dBASE you’ll need to change the dates every time you use it.

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