case-key-handover-date-field-location-and-semantics

Key_Handover_Date__c is a date field directly on the Case object in Runwal’s Salesforce org — not on the related Opportunity. When business users say ‘aging from Key Handover Date greater than 90 days’, the correct SOQL condition is Key_Handover_Date__c < (TODAY minus 90 days), since all KHD values are historical possession dates in the past, not future targets.