+ Start a Discussion
buggs sfdcbuggs sfdc 

Soql Query to check the recently created columns on sobjects

HI,

Can we write any Soql Query to fetch the newly created columns on any sobject on weekly basis?

Thanks  In Adavance!
Manish BhatiManish Bhati
Have you tried below:-
SELECT Id FROM Account WHERE CreatedDate > LAST_WEEK

It will show all records from 12:00:00 on the first day of the week before the most recent first day of the week and continues for seven full days. Your locale determines the first day of the week. According to SFDC doc.
buggs sfdcbuggs sfdc
HI Manish

Thanks for the quick reply,but i dont need any data i need metadata,in the colums/fields which are created on the lastweek
hope you are clear what am trying to query?

Thanks Again!
Manish BhatiManish Bhati
Oh, my bad will try to read carefully.

We cannot get more than one record in SOQL. 
Also Tooling API FieldDefinition can be helpful.