The below query doesn't return any results
select Phone__c from Application__c where Orientation_Date__c < NEXT_N_DAYS:8 and Orientation_Date__c > NEXT_N_DAYS:1
But the next query returns 2 records with
select Phone__c from Application__c where Orientation_Date__c > NEXT_N_DAYS:1
2017-07-25 so these 2 records should meet the criteria for the first query right? Why aren't they being returned?