Author Topic: Getting the created date of a contact (Read 1467 times)

torenware · May 10, 2010, 07:47:28 pm

I'm looking through the 3.1 UI and schema to see if there's any way to get the created date of a contact. I get asked about this a fair bit, and AFAICT, there isn't a way to do this.

First, why???

It would be pretty easy to create a column that would auto-fill with this, which would solve the problem. That's such an obvious solution that I'm curious why no one's ever done it.

If there is a way to do this (since there isn't a slot for this in civicrm_contact), how do you do it?

Donald Lobo · May 11, 2010, 07:37:38 am

check civicrm_log. the created date/id is stored there. the first entry for a contact stores this info

lobo

john.grosjean · May 26, 2010, 07:44:51 am

I noticed that about the change log, but how would you create a report based on that? I need to include the number of new contacts in my monthly report. I'm still very new to CiviCRM, but I think I'm with torenware about this being a built-in feature in a future release.

Donald Lobo · May 26, 2010, 07:58:58 am

steps to write a report:

http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+structure+and+customization

if you are not a developer, consider hiring one and submitting the report back to the project. That way everyone can benefit and use that report

as an open source project, we rely on the contributions of users like you to fill in the gaps

lobo

xavier · May 26, 2010, 11:24:13 pm

This chapter might be of interested as well

http://en.flossmanuals.net/CiviCRM/DevelopReports

petednz · May 27, 2010, 03:29:17 pm

For people who might be searching and find this, thought it would be helpful to point out that there is a Custom Search civicrm/contact/search/custom&reset=1&csid=11 that works on Date Added in case you want to find 'those people who were added in the last week'. Doesn't do what a Report does, but gives you the numbers if you need them.

IE if you just want to say, in Feb the number of contacts added to the DB were xxx then you can get this from the Custom Search I believe

CiviCRM Community Forums (archive)

News:

Author Topic: Getting the created date of a contact (Read 1467 times)

torenware

Getting the created date of a contact

Donald Lobo

Re: Getting the created date of a contact

john.grosjean

Re: Getting the created date of a contact

Donald Lobo

Re: Getting the created date of a contact

xavier

Re: Getting the created date of a contact

petednz

Re: Getting the created date of a contact