My Requirement is "the records should be considered next only when they complete 12 months" and this is monthly exercise so if i query the data from database it should not include the previous data.
suppose I have
sent_Date__C custom field(which stores date of record used or query date), when ever i query data i need to use
sent_Date__C field and get data from database.
the previous data should be included when the difference of
sent_Date__C field and tdys date should be 1 year.
I want the data using SOQL.