You need to sign in to do that
Don't have an account?
data.migration1.3948976100296348E12
Custom Report Data Wrong
Hi,
This is logic, here only change logic
if((Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c != null) && Assignment.Deactivation_Date__c > EndDatesMap.get(MonthKey))
continue;
else if((Assignment.Effective_Date__c != null && Assignment.Deactivation_Date__c == null) && Assignment.Effective_Date__c <= EndDatesMap.get(MonthKey))
continue;
else if((Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c ==null) || (Assignment.Effective_Date__c<=EndDatesMap.get(MonthKey) && Assignment.Deactivation_Date__c > EndDatesMap.get(MonthKey)) || (Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c > EndDatesMap.get(MonthKey)) || (Assignment.Deactivation_Date__c == null && Assignment.Effective_Date__c <= EndDatesMap.get(MonthKey)))
This is logic, here only change logic
if((Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c != null) && Assignment.Deactivation_Date__c > EndDatesMap.get(MonthKey))
continue;
else if((Assignment.Effective_Date__c != null && Assignment.Deactivation_Date__c == null) && Assignment.Effective_Date__c <= EndDatesMap.get(MonthKey))
continue;
else if((Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c ==null) || (Assignment.Effective_Date__c<=EndDatesMap.get(MonthKey) && Assignment.Deactivation_Date__c > EndDatesMap.get(MonthKey)) || (Assignment.Effective_Date__c == null && Assignment.Deactivation_Date__c > EndDatesMap.get(MonthKey)) || (Assignment.Deactivation_Date__c == null && Assignment.Effective_Date__c <= EndDatesMap.get(MonthKey)))
Here i am selecting custom report from month 'JAN' to month 'JAN' it's working fine showing 160 records.
now am selecting from month 'JAN' to month 'APR' it's showing JAN month '0' records
month rage is max four months.