Microsoft Dynamics CRM (Archived)

Passing date to oData query

(0) Share

Report

Posted on by Drew Inc.

1,680

Hello,

Here is my code to retreive data using oData Query

var startTime = Xrm.Page.getAttribute("scheduledstart").getValue();
var endTime = Xrm.Page.getAttribute("scheduledend").getValue();

odataQuery = "ServiceAppointmentSet?$select=ScheduledEnd,ScheduledStart&$filter=ActivityId ne guid'" + currServiceAppointmentID + "' and StatusCode/Value eq 4 and ScheduledStart lt datetime'" + endTime + "' and ScheduledEnd gt datetime'" + startTime + "'";

Which fails because of Data-time conversion, Can anyone let me know how to convert the datatime to Edm.DateTime which is accepted by oData.

Thanks

Drew

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (4)

Verified answer

Abed Haniyah 4,287 on at

Like (0)

Report

Hi,

Please refer to Aileen's post :missdynamicscrm.blogspot.com/.../crm-2011-crm-2013-odata-datetime.html

Hope this helps,

Abed.

Was this reply helpful? Yes No
Verified answer

Rajkumar Rajaraman on at

Like (0)

Report

Hi Drew,

Walkthrough the following article. It explains how to convert the datatime to Edm.DateTime in deeply.

missdynamicscrm.blogspot.in/.../crm-2011-crm-2013-odata-error-when.html

Hope this helps.

Regards,

R.Rajkumar

Was this reply helpful? Yes No
Verified answer

ashishkhanna 180 on at

Like (0)

Report

I agree with the approach others explained here but I have found this tool really helpful to generate odata queries without getting too much into the code

dynamicsxrmtools.codeplex.com

Was this reply helpful? Yes No
Verified answer

Mahendar Pal 45,095 on at

Like (0)

Report

You can also check this: blogs.catapultsystems.com/.../crm-2013-handling-odata-date-field-value

Thanks

Was this reply helpful? Yes No
Drew Inc. 1,680 on at

Like (0)

Report

Thanks that helped a lot!!

Was this reply helpful? Yes No