I have a schedule apex job that runs everyday in the morning at 2 AM, where I am trying to gather opportunities where custom date Reoffer_Date__c
as today.
List opportunitiesList = [
SELECT Id, Name, Employee_Contact__c, RecordTypeId, Employee_Contact__r.Gross_Income__c
FROM Opportunity
WHERE Reoffer_Date__c = System.TODAY()
];
SELECT Id FROM Opportunity WHERE Reoffer_Date__c = TODAY