Parsing date in Json Encoded array

Question

I have built a MVC site and I am passing in my model to the view and attempting to use it in some javascript in the view using:

var records = @Html.Raw(Json.Encode(Model));

I am aiming on using these records in a custom calendar object that accepts an object array as a datasource. However, the datasource expects date variables to know where to put appointments etc. I've read that Json does not have any date format of it's own. So, all the dates that are returned from the encode are formatted like:

/Date(1462921200000)/

The object doesn't seem to accept this and nothing is shown on the view. In the posts that I've read they have stated that you can parse the date back into the correct format but this seems to be only on individual values.

My question is: is there an easy way to take the encoded object I've got and parse the dates into the correct format? Or would I have to loop through them in order to do it?

Thanks.

That doesn't look like raw JavaScript. Are you using a preprocessor technology? — Álvaro González
– Álvaro González, Commented Feb 21, 2017 at 17:21

Alberto Chiesa · Accepted Answer · 2017-02-23 16:34:44Z

Warning: This answer is opinionated. The opinionated part is: when you need something done with Json, use Json.Net.

namespace System.Web.MVC
{
  public static class HtmlHelperJsonExtensions
  {
    public string JsonEncode(this System.Web.MVC.HtmlHelper html, object o)
    {
      var jsonSettings = new Newtonsoft.Json.JsonSerializerSettings()
      {
        // Here you can apply a LOT of formatting, as a small example regarding dates:
        // 1 - formats dates as iso strings (probably what you want)
        DateFormatHandling = Newtonsoft.Json.DateFormatHandling.IsoDateFormat,
        // 2 - formats dates with Microsoft format (what you're experiencing)
        //DateFormatHandling = Newtonsoft.Json.DateFormatHandling.MicrosoftDateFormat,
        // 3 - formats date in a custom format as for DateTime.ToString(string) overload
        //DateFormatString = "yyyy-MM-dd"
        Formatting = Indented
      };

      var json = Newtonsoft.Json.JsonConvert.SerializeObject(o, jsonSettings);

      return html.Raw(json);
    }
  }
}

Usage:

var records = @Html.JsonEncode(Model);

Refer to the excellent Json.Net documentation here for insights.

Darion Badlydone · Accepted Answer · 2017-02-21 17:09:04Z

0

Asp.Net MVC application return the dates in the ISO-8601 format by default. You can convert the value in the client side with a function like this:

function ConvertDate(dateString) {
    return new Date(parseInt(dateString.replace("/Date(", "").replace(")/", ""), 10));
  }

Or you can use a library like momentjs (https://momentjs.com/docs/#/parsing/asp-net-json-date/):

moment("/Date(1198908717056-0700)/"); // 2007-12-28T23:11:57.056-07:00

answered Feb 21, 2017 at 17:09

Darion Badlydone

1,0192 gold badges17 silver badges40 bronze badges

Comments

Álvaro González · Accepted Answer · 2017-02-23 15:37:11Z

0

Disclaimer: question was not identified as ASP.NET when I composed this answer. I presume the OP is asking for some feature provided by his yet to be disclosed framework. I keep the answer because I think it's valid for manual decoding in vanilla JavaScript.

The format can be parsed with a simple regular expression

var asText = "Date(1462921200000)";
var asDate = null;
var parsed = asText.match(/^Date\((\d+)\)$/);
if (parsed!==null) {
	asDate = new Date(+parsed[1]);
}
console.log(asDate);

edited Feb 23, 2017 at 15:37

answered Feb 21, 2017 at 17:27

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Collectives™ on Stack Overflow

Parsing date in Json Encoded array

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related