Answers.Body: <p>You can use <code>date_created</code> on the <code>civicrm_contact</code> table.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-03T05:31:35.853Z
Answers.Text: There is no column called date_created in civicrm_contact. We are on 4.1.5
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-03T15:15:24.517Z
Answers.Text: Well there's your problem :)  Is there a reason to stay on Civi 4.1.5?  That's an out-of-date and insecure version - and of course created_date was added in 4.3.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-04T05:21:59.497Z
Answers.Text: No budget to upgrade yet. I can look at the first row created in the subscription_history table which is good enough.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-03T04:37:49.183Z
Answers.LastActivityDate: 2015-08-03T04:37:49.183Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Check the table civicrm_log. The column entity_table will contain civicrm_contact and the column entity_id the id of the contact you are looking for. Does that help? If you want more specific information you need to explain what you are trying to do :-)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-04T05:23:28.020Z
Answers.Text: I am selecting the created column for the in last user created in Drupal and want to show the date the corresponding CiviCRM record was created.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-02T08:07:39.720Z
Answers.LastActivityDate: 2015-08-02T08:07:39.720Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I'm trying to determine the correct table and column to check the data a contact was added to the civicrm-contact table. What is the best method for doing this?</p>
  
Tags: <contacts><database><data-model>
Title: What table and column contain the date a contact was added?
ThreadText: # What table and column contain the date a contact was added?
  
  (Asked by: username_0 on 2015-08-02)
  
  I'm trying to determine the correct table and column to check the data a contact was added to the civicrm-contact table. What is the best method for doing this?
  
  **Tags:** contacts, database, data-model
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-08-03. Score: 2
  
  You can use `date_created` on the `civicrm_contact` table.
  
  > **Comments:**
  > **username_0**: There is no column called date_created in civicrm_contact. We are on 4.1.5  
  > **username_1**: Well there's your problem :)  Is there a reason to stay on Civi 4.1.5?  That's an out-of-date and insecure version - and of course created_date was added in 4.3.  
  > **username_0**: No budget to upgrade yet. I can look at the first row created in the subscription_history table which is good enough.  
  
  ---
  
  ### Answer by username_2 on 2015-08-02. Score: 1
  
  Check the table civicrm\_log. The column entity\_table will contain civicrm\_contact and the column entity\_id the id of the contact you are looking for. Does that help? If you want more specific information you need to explain what you are trying to do :-)
  
  > **Comments:**
  > **username_0**: I am selecting the created column for the in last user created in Drupal and want to show the date the corresponding CiviCRM record was created.  
  
  ---
  
  