filtering on fractions of a second requires the use of the function fractionalseconds()
https://api.bridgedataoutput.com/api/v2/OData/abor_ref/Property?$top=4&$select=ListingKey,BedroomsTotal,Directions,ListingContractDate,ModificationTimestamp,StandardStatus,PropertyType,City,PublicRemarks&$filter=year(ListingContractDate) eq 2017 and month(ListingContractDate) eq 5 and day(ListingContractDate) eq 31 and hour(ModificationTimestamp) gt 13 and minute(ModificationTimestamp) gt 3 and fractionalseconds(ModificationTimestamp) lt 33 and PropertyType eq 'Residential'
HAR: This function may not work with ModificationTimestamp (incompatible types)
Top ▴