I'm trying to do a large scale field cleanup within my org, and I'm looking to get a list of the custom fields by object (in this case the Account sobject), some basic details for those fields, and most importantly the created date of those fields. I cannot figure out how to get the created date though - which seems very odd.
Within the developer console, I'm using the Query Editor tab, and I'm entering in the following query:
SELECT QualifiedApiName, LastModifiedDate, DeveloperName, (Select DataType From Particles) FROM FieldDefinition WHERE EntityDefinition.QualifiedApiName ='Account'
I should note that I have the "Use Tooling API" checkbox enabled. If I enter in the CreatedDate attribute I get the following error back:
ERROR at Row:1:Column:44 No such column 'CreatedDate' on entity 'FieldDefinition'.
Can someone please point me in the right direction here? Seems very odd that I can't pull in the CreatedDate of a custom field, so I believe I'm doing something wrong.