How can I determine the creation date and/or user who created a contact record?

Version 1

    Details

     

    How can I determine the creation date and/or user who created a contact record?

    Note: This information is represented on the "Summary" tab of a contact record
    Field: "Creation" = Create date and user created
     



     


    Resolution

     

    On the "Summary" tab, the field "Creation" is a combination of the partial "accountno" and the "createby" values within the database of a contact record. As this is a combination of 2 fields and not a separate field in the database and also would require a 'translation' of the "accountno" the more user friendly approach is to use the "createon" and "createby" field from the CONTACT1 table to achieve the desired information. 

    The fields "createon" and "createby" can be added to a filter/group or to the Contact Search Center to extract this data for multiple contact records. These fields will not display on a contact record by default and the field values are non-editable.

    Once a filter or group of contacts has been created (Knowledge Base articles 17242 and 14929 respectively), this data can be exported into a .csv file with above fields and field values. The exported data can then be manipulated/filtered within the saved .csv file.

    Note: The "createon" and "createby" fields format is as follows:

    "createon" date format = MM/DD/YYYY 
    "createby" value format = GoldMine user ID