Dynamics Community Forum Thread Details

Xrm.WebApi.retrieveMultipleRecords issue with stored UTC date/time

User records were batch imported. At the time if import, dataverse recorded

{@odata.etag: 'W/"27078907"', cr249_snpclientid: 'ec2515d8-xxxx', cr249_dateofbirth@OData.Community.Display.V1.FormattedValue: '12/15/1950', cr249_dateofbirth: '1950-12-16T00:00:00Z', cr249_lastname: 'Smith'}

I try to implement Xrm.WebApi.retrieveMultipleRecords to filter out those that were born, say 12/16/1950 based on the date picked from a calendar. But the search will filter by the actual UTC date stored in the record and return those with birthdate 12/15/1950. I need to find a way to make it search based on the OData.Community.Display.V1.FormattedValue or somehow convert the date using timezoneoffset so that 12/16/1950 should become 12/17/1950 in order to get those with FormattedValue 12/16/1950.

var searchDob = birthDate.toISOString().split("T")[0] + "T00:00:00.000Z";
Xrm.WebApi.retrieveMultipleRecords("cr249_snpclient", "?$select=cr249_dateofbirth,cr249_lastname&$filter=cr249_dateofbirth eq " + searchDob).then(

Categories:

Dynamics 365 Guides

Quick Links