Date format is very important when we use date field in SOQL.


Sample Query:

SELECT Name, Joining_Date__c FROM Order_Line_Items__c WHERE Joining_Date__c = 2014-02-03

Cheers!!!