News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Filter Dynamics 365 CR...

Microsoft Dynamics CRM (Archived)

Filter Dynamics 365 CRM query on datetime columns issu

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hey,

I'm trying to run an OData Query in Dynamics 365 to filter on a datetime field and get the following error:

{ "code": "", "message": "Unrecognized 'Edm.String' literal 'datetime'2017-07-10T10:10:36Z'' at '81' in 'modifiedon ge datetime'2017-07-10T10:10:36Z''.", "innererror": { "message": "Unrecognized 'Edm.String' literal 'datetime'2017-07-10T10:10:36Z'' at '81' in 'modifiedon ge datetime'2017-07-10T10:10:36Z''.", "type": "Microsoft.OData.Core.ODataException", "stacktrace": "...

What is wrong with this query: modifiedon ge datetime'2017-07-10T10:10:36Z'

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Filter Dynamics 365 CRM query on datetime columns issu

Hi, I'm having exactly the same issue and get a Bad Request response when filtering accounts using this: modifiedon ge datetime'2017-11-13T13:41:35Z'.

I've also tried Microsoft.Dynamics.CRM.OnOrAfter(PropertyName=@p1,PropertyValue=@p2)&@p1='modifiedon'&@p2='2017-11-13T13:41:35Z', this doesn't error however it doesn't filter the data returned.

Has anyone got a solution to this?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans