1,086
Hi, I'd like to query a record by date
https://org.crm.dynamics.com/api/data/v9.2/contacts?$filter=modifiedon eq 2022-05-02
but it returns empty response
but I am sure that there are records that match that condition
this is querying all
what am i missing? thx
Hi PabloCRP,
I tested this on my side and get the same result with you. Then I change the url like this:
https://org.crm.dynamics.com/api/data/v9.2/contacts?$filter=modifiedon ge 2022-05-03 and modifiedon lt 2022-05-04
It could work fine:
you should use Microsoft.Dynamics.CRM.On instead of eq if you want to consider just the date part, however you can use my tool Dataverse REST Builder to test the filter conditions
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (