[SalesForce] Difference between System.today() and System.today().day() in apex

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()
];

Best Answer

As already proposed in the comments section, please tak a look at date literals like TODAY:
Date Formats and Date Literals

In terms of day(), it returns the day-of-month component of a Date (documentation). So if you want to have a full date, it's not the way to go.

As for the today, it returns current date (honoring user's time zone) indeed. It would be best for you to just review existing methods for System Class.

Related Solutions

[SalesForce] Mass deletion of records through apex

You could create a class that implements the schedulable interface and do something like this:

global class ScheduledDelete Implements Schedulable {

    global void execute(SchedulableContext sc) {

        massDelete();

    }

    public void massDelete() {
        List <training__c> listtoDelete = [Select Id FROM training__c WHERE CreatedDate CreatedDate = LAST_N_DAYS:180];
        delete listtoDelete;
    }


}

Then, you can schedule the class to run daily from an anonymous block or by going to Setup > Develop > Apex Classes > Schedule Apex.

[SalesForce] Apex Scheduler stays queued

Look at this:

Why do I see Apex jobs in Queued status on the "Apex Jobs" page?

By design, scheduled Apex jobs will always stays in the Queued status until the job has no NextFireTime, then it gets marked Completed, or if the job is aborted, then the AsyncApexJob row gets marked Aborted.

update:

In provided code you are not inserting opportunity.

Best Answer

Related Solutions

[SalesForce] Mass deletion of records through apex

[SalesForce] Apex Scheduler stays queued

Related Topic