I have two queries for identifying customers for promotion. The first target is composed of customers who did their last purchase more than 30 days from the current date and the WHERE clause works properly with the following structure:
WHERE GETDATE() - Order_Date__c >30
When I have to identify customers who did their last purchase exactly 30 days ago,changed the WHERE clause as follows
WHERE GETDATE() - Order_Date__c =30
but it doesn't work as the result is the same as for >30 days.
What is wrong with the above?