Tuesday, December 1, 2009

GoldMine: Finding New Contacts Added

A client way: Is there a way to find any new contacts added to GoldMine and export them to Excel?

Yes, there are several ways. Some examples are below:

Option 1: Select the Contact Search Center > Search CREATEON greater than 10/1/2009

Option 2: Use a SQL Query

Query 1:
select contact, company, city, state, phone1, key1, createon from contact1 where accountno >= 'A91001%'

Query 2:
select * from Contact1 where (CreateOn > { fn NOW() } - 30) order by CreateOn

Query 3:
select contact, company, city, state, phone1, key1, createon from contact1 where createon >= '20091001'

Note: In Query 1 above: "A91001%" - "A9" represents the year 2009 ..."10" is October .... "01" is the first day. Also, any results can be exported to Excel by right clicking and selecting Output To.

No comments: