If you want to filter record 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.