Filtering on a date requires date fields to be defined as dates (Type=”Edm.Date”) in the metadata
https://api-prod.corelogic.com/trestle/odata/Property?$filter=ListingContractDate lt 2017-12-31 and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'NTREIS')&$top=5&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,ListingContractDate
The function now() will return the now time in UTC
https://api-prod.corelogic.com/trestle/odata/Property?$filter=ModificationTimestamp le now() and (PropertyType eq 'Residential') and (OriginatingSystemName eq 'NTREIS')&$select=ListingKey,BedroomsTotal,PropertyType,StreetName,StreetNumber,City,ModificationTimestamp,OriginatingSystemName,Appliances,ListingContractDate,AssociationFeeFrequency,ModificationTimestamp&$top=5
