Apex method does not return result as expected

Question

I use an apex method that takes as inputs 2 dates. And i query on events and then i return the list of events. My code is this:

@AuraEnabled
public static List<Event> getEventsForDateRange(String fromDate, String endDate){
    try{
        date date1 = date.valueOf(fromDate);
        date date2 = date.valueOf(endDate);
        List<Event> eventsList = [select id, Subject, OwnerId, StartDateTime, EndDateTime, Street__c, City__c, Country__c, Postal_Code__c from Event
        where ownerId =: UserInfo.getUserId() AND StartDateTime >: date1 AND StartDateTime <=: date2];
        return eventsList;
    } catch(Exception e) {
        throw new AuraHandledException('Error! ' +e.getMessage());
    }
}

But i give as inputs:fromDate 2020-04-08 and endDate 2020-04-09. And despite the fact that i have events in 09/04/2020 and the owner is my user, the method returns an empty list... Could anyone explain me what i am doing wrong? This is the system.debug that i run in my anonymous console

system.debug(fullCalendarController.getEventsForDateRange('2020-04-08','2020-04-09'));

Answer 1

So after a lot of debugging i found solution! Here is my code that works as expected

@AuraEnabled
public static List<Event> getEventsForDateRange(Date fromDate, Date endDate){
    try{
        Time myTime = Time.newInstance(0, 0, 0, 0);
        Datetime fromDt = DateTime.newInstance(fromDate.addDays(1), myTime);
        Datetime toDt = DateTime.newInstance(endDate.addDays(1), myTime);
        system.debug('we have from date: ' +fromDt);
        system.debug('we have to date: ' +toDt);
        List<Event> eventsList = [select id, Subject, OwnerId, StartDateTime, EndDateTime, Street__c, City__c, Country__c, Postal_Code__c from Event
        where ownerId =: UserInfo.getUserId() AND StartDateTime >: fromDt AND StartDateTime <=: toDt];
        for (Integer i=0; i<eventsList.size(); i++) {
            system.debug(eventsList[i].Subject);
            system.debug(eventsList[i].startDateTime);
        }
        system.debug('The query is: select id, Subject, OwnerId, StartDateTime, EndDateTime, Street__c, City__c, Country__c, Postal_Code__c from Event where StartDateTime > ' +fromDt+ ' AND StartDateTime <= ' +toDt);
        return eventsList;
    } catch(Exception e) {
        throw new AuraHandledException('Error! ' +e.getMessage());
    }
}

Answer 2

You have to pass Date in String format and in the Apex convert it back to Date for Date and Integer Apex returns null.

@AuraEnabled
public static List<Event> getEventsForDateRange(String fromDate, String endDate){
  Date startDateValue = Date.valueOf(fromDate);
  Date endDateValue = Date.valueOf(endDate);
  try{
    List<Event> eventsList = [select id, Subject, OwnerId, StartDateTime, EndDateTime, Street__c, City__c, Country__c, Postal_Code__c from Event
     where ownerId =: UserInfo.getUserId() AND StartDateTime >: startDateValue AND StartDateTime <=: endDateValue];
    return eventsList;
    } catch(Exception e) {
    throw new AuraHandledException('Error! ' +e.getMessage());
  }
}