Convert date value to JSON format

(0) Share

Report

Posted on by Community Member

Hi, I am trying to convert the createdon date to JSON format.

var createdOn = Xrm.Page.getAttribute("createdon").getValue();

This gives createdOn = Wed Jan 13 2016 14:01:49 GMT-0500 (Eastern Standard Time)

However, I need the JSON format (2016-01-13T14:01:49). The issue is that I am trying to get the created on date + 7 days, and using this info for a query.

Is there such method to convert this easily? I know that there is a way to add 7 days using the Date object in JScript, I am just not sure how to take this raw date value and convert to any reasonable format.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
I wrote a solution to this for anyone who needs it:

function convertDateToJSON(rawdate) { var res = rawdate.toString().split(" "); var time = res[4].split(":"); var tempdate = new Date(); var formattedtime = new Date(tempdate.setDate(rawdate.getDate() + 7)); formattedtime = new Date(formattedtime.setHours(time[0])); formattedtime = new Date(formattedtime.setMinutes(time[1])); formattedtime = new Date(formattedtime.setSeconds(time[2])); var parsed = formattedtime.toString().split(" "); var JSONformat = parsed[3] + "-" + getmonth(parsed[1]) + "-" + parsed[2] + "T" + parsed[4]; return JSONformat; } function getmonth(month) { switch (month) { case "Jan": return "01"; break; case "Feb": return "02"; break; case "Mar": return "03"; break; case "Apr": return "04"; break; case "May": return "05"; break; case "Jun": return "06"; break; case "Jul": return "07"; break; case "Aug": return "08"; break; case "Sep": return "09"; break; case "Oct": return "10"; break; case "Nov": return "11"; break; case "Dec": return "12"; break; } }

This converts the raw date you receive from using getValue on a date field and converts it to a JSON format, which then can be added to a query (such as OData).

Was this reply helpful? Yes No
nickmanny 136 on at

Like (0)

Report
JSON does not know anything about dates. What .NET does is a non-standard hack/extension. The problem with dates in JSON and really JavaScript in general – is that there's no equivalent literal representation for dates. In JavaScript following Date constructor straight away converts the milliseconds since 1970 to Date as follows:

var jsonDate = new Date(1297246301973);

Then let's convert it to js format:

var date = new Date(parseInt(jsonDate.substr(6)));

The substr() function takes out the /Date( part, and the parseInt() function gets the integer and ignores the )/ at the end. The resulting number is passed into the Date constructor .

Was this reply helpful? Yes No
Guido Preite 54,086 Moderator on at

Like (0)

Report
it's an old thread, however it's not required to do that kind of parsing

when you do a getValue from a form attribute you get a JavaScript Date object and to convert to JSON you just use toJSON function, like this:

var now = new Date(); var nowJSON = now.toJSON();

nickmanny your answer doesn't resolve the initial question and please don't copy&paste your response from here https://stackoverflow.com/a/10286228/2191473 and the link you left in your answer http://net-informations.com/jq/iq/jdate.htm.

Because this is not a .NET problem and the code you pasted actually doesn't work

Was this reply helpful? Yes No