Date Function Examples

Year

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

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

Month

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

Day

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

Hour

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

Minute

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

Second

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

Date

https://h.api.crmls.org/RESO/OData/Member?$filter=date(ModificationTimestamp)+ge+date(OriginatingSystemModificationTimestamp)

Time

https://h.api.crmls.org/RESO/OData/Member?$filter=time(OriginatingSystemModificationTimestamp)+lt+time(ModificationTimestamp)

Now

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