apex query to get the created date eualent records in where clause code example
Example 1: string literal soql date format
//Date only:
YYYY-MM-DD 1999-01-01
//Date, time, and time zone offset: YYYY-MM-DDThh:mm:ss+hh:mm
YYYY-MM-DDThh:mm:ss-hh:mm
YYYY-MM-DDThh:mm:ssZ
1999-01-01T23:01:01+01:00
1999-01-01T23:01:01-08:00
1999-01-01T23:01:01Z
Example 2: soql more than today
SELECT Date__c FROM Object__c
WHERE Date__c < TODAY
ORDER BY Date__c DESC
LIMIT 1