Date Function Examples

Year

https://h.api.crmls.org/RESO/OData/OpenHouse?$filter=year(SourceDateModified)+eq+2013

{
  "@odata.context": "https://h.api.crmls.org/RESO/OData/$metadata#OpenHouse",
  "value": []
}

Month

https://h.api.crmls.org/RESO/OData/OpenHouse?$filter=month(SourceDateModified)+eq+9

Day

https://h.api.crmls.org/RESO/OData/OpenHouse?$filter=day(SourceDateModified)+eq+1

Hour

https://h.api.crmls.org/RESO/OData/OpenHouse?$filter=hour(SourceDateModified)+eq+8

Minute

https://h.api.crmls.org/RESO/OData/OpenHouse?$filter=minute(SourceDateModified)+eq+35

Second

https://h.api.crmls.org/RESO/OData/OpenHouse?$filter=second(SourceDateModified)+eq+10

Date

https://h.api.crmls.org/RESO/OData/Property?$filter=date(ExpirationDate)+ge+date(EndingDate)

Time

https://h.api.crmls.org/RESO/OData/Property?$filter=time(OffMarketTimestamp)+lt+time(PhotosChangeTimestamp)

Now

https://h.api.crmls.org/RESO/OData/Property?$filter=OffMarketTimestamp+lt+now()