Filtering by date

If you want to filter customer detail records by date—for example, the date the records were created, birth date of customers, date of last contact with customers—you must specify the date as an exact date or using a date literal. For further information about specifying dates, see Date Formats and Date Literals in Salesforce help.