Archive
Posts Tagged ‘date conversion’
Type-cast OData Service Datetime field in crm 2011
August 21, 2011
10 comments
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 🙂
Categories: CRM 2011, JScript
/Date, CRM 2011, CRM date, CRM datetime, date conversion, date field, datetime field, Edm.DateTime, ODATA Date, type cast