web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) ODATA Get DateTime Year

Microsoft Dynamics CRM (Archived)

ODATA Get DateTime Year

(0) Share

Report

Report

Posted on by Community Member

Hi guys,

I have a javascript code which gives me records as query result with SDK.REST.retrieveMultipleRecords

One of the field I want to query is a DateTime field.

If I try to read the field value, I got this string value:

Fri Jul 17 2015 08:30:26 GMT+0200 (W. Europe Daylight Time)

How can I get the year, month, and day of the field instead this string format ?
Thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Suggested answer

Royal King 27,686 on at

Like (2)

Report
Copy link

Link copied!

use below method to parse odata date time to datetime

var datetime = new Date( parseInt( dt.replace(“/Date(“, “”).replace(“)/”, “”) ,10))

Or

new Date(DateField.match(/\d+/)[0] * 1) // replace DateField with your field name that holds datetime value in odata format

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Chitra,

im on javascript

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I see.

My problem was that the object was stored in an associative array and somehow I couldnt execute those function. Now I have copief the value to a variable and can then successfuly access those function.

Thanks.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

AS-17030037-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans