Published by

Rajeev Pentyala

August 21, 2011

Hi,

When you read any CRM DateTime value using OData Service, the value comes in “/Date(1314763200000)/“ format, which we can’t directly set to DateTime field.

Reason :-

OData parses data in “Edm.DateTime” type

<d:new_StartDate m:type=”Edm.DateTime”>2011-08-18T04:00:00Z</d:IBT_StartDate>

How to Type Cast to DateTime :-

Use below code to type cast OData DateTime type (i.e., Edm.DateTime) to CRM DateTime

var dt = ODataEntity.results[0].new_StartDate;
                    dt = dt.replace(“/Date(“, “”);
                    dt = dt.replace(“)/”, “”);
                    var dateValue = new Date(parseInt(dt, 10));
                    dateValue.setDate(dateValue.getDate());
                    Xrm.Page.data.entity.attributes.get(“{fld_name}”).setValue(dateValue);

Hope it helps 🙂

10 responses to “Type-cast OData Service Datetime field in crm 2011”

Gilberto Tezini

September 21, 2011

Hi Rajeev,

Very usefull article, helped me a lot.

Congratulations!

Reply
Lokesh Mishra

November 3, 2011

Rearly a ncie post, spent hours searching before i bumped into it… thanks a lot for the solution cheerz 🙂

Reply
Deepesh Somani

March 21, 2012

It helped me also..Thanks rockstar..

Reply
Cast OData Date to Standard Javascript Date Time | Code Chex

March 27, 2013

[…] Thank you to Rajeev Pentyala for this solution (link) […]

Reply
ASd

May 29, 2013

That’s it. Thanks

Reply
Naresh Veginati

January 22, 2014

Hi Rajeev,
It’s very interesting. Can help me on this. Am trying to get the Appointments by startdate and end date. my query is bellow. but it’s giving results as empty
$filter=ScheduledStart eq datetime’2014-01-23T04:00:00′ and ScheduledEnd eq datetime’2014-01-23T08:30:00′ .

Can you help me. how to get the record! 🙂

Reply
1. Rajeev Pentyala
  
  January 23, 2014
  
  Hi Naresh,
  
  Have u tried the query using OData Query Designer? I am able to get the records.
  
  Reply
Naresh Veginati

January 23, 2014

Yes. It’s coming with le and ge operation, still issues persist with date time…
Am updating date time as 23/01/2013 4:30 PM. Its showing on form as same. But when call ODATA service it’s returning date time as ’24-01-2013T22:30:00Z’.
How it is possible?

Reply
dave

October 30, 2014

time zone differences, i.e. it comes back from CRM as UTC

Reply
amit

January 1, 2015

Hi Rajeev,

I retrieved value in UTC format but i want to add days in Retrieved Date i am doing something like this but when i add Days in retrieved then i am getting some unexpected results.
var shipmentdate = oppProduct[0].results[0].ap_shipmentdate;
var DateValue = new Date(parseInt(shipmentdate.replace(“/Date(“, “”).replace(“)/”, “”), 10))
var newdate = new Date().setDate(DateValue.getDate() + 5);
window.parent.Xrm.Page.getAttribute(“ap_testdate1”).setValue(newdate);

Thanks in advance..

Reply