javascript .substr breaks alert method

Question

I'm trying to pull the hours and minutes out of a Microsoft JSON string. I've gone through several articles, the most recent one being: How do I format a Microsoft JSON date? to no avail. When I try to follow the example code provided.

The alert won't fire. Not sure what I'm doing wrong or missing. The pertinent code is here:

$.ajax({
  type: "GET",
  url: "/TrainActivity/GetDelayDataForEditing/" + "?delayId=" + delId,
  dataType: 'json',
  //data: delId,
  success: function(data) {
    //data = JSON.stringify(data);
    //$("#myDivID").text(JSON.stringify(data));
    //var delayId = delId;

    modal.find('');
    //This is my code based off stack overflow article, and it breaks the alert
    var date = new Date(parseInt(data.beginDelayDateTime.substr(6)));

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

    //this date is okay
    //var date = new Date();
    var unparsedDate = moment(data.beginDelayDateTime);
    var parsedDate = new Date(unparsedDate);
    var hours = parsedDate.getHours;
    var minutes = parsedDate.getMinutes;
    var timeToDisplay = hours + ":" + minutes;
    //var timeToDisplay = JSON.stringify(hours) + ":" + JSON.stringify(minutes);

    alert("Success " +
      //"\ntest date: " + date +
      "\nunparsed date: " + unparsedDate +
      "\nParsed date: " + parsedDate +
      "\nDisplay time: " + timeToDisplay +
      "\nbegin Delay time: " + data.BeginDelayDateTime
    );

    //$('#delays-grid').data('kendoGrid').dataSource.read();
    //$("#delayAddModal").modal("hide");

  },
  error: function() {
    alert("error in Delay Edit");
  }
});

//modal.find(".modal-body").text("Edit the Delay at " + name + " with id " + delId);
modal.find(".modal-footer #delayEditButton").data("guid", delId);
});

data.beginDelayDateTime has /Date(1531958520000)/ in it and that value ("/Date(1531958520000)/") displays in the alert with no problems.

If the alert doesnt fire, there is probably an error inbetween. — Jonas Wilms, Jul 19 '18 at 19:31
Please don't comment out the code that you're asking about. SO's syntax highlighting makes it hard to read. — Barmar, Jul 19 '18 at 19:32
The problem is most likely with parseInt failure. First examine the contents of `jsonDate` and then `jsonDate.substr`. Verify that the string returned by `jsonDate.substr` contains only numbers. — Kaushik, Jul 19 '18 at 19:33
In the question you link to, `jsonDate` is the parameter to the `formatJSONDate()` function. You copied the variable name, but not the function, so the variable has no meaning. — Barmar, Jul 19 '18 at 19:34
@Kaushik I'm not using jsonDate. I'm using data.BeginDelayDateTime. — BeginnerOne, Jul 19 '18 at 19:42
The question says that when you try to use `var date = new Date(parseInt(jsonDate.substr(6)));` the alert doesn't fire. That's using `jsonDate`. — Barmar, Jul 19 '18 at 19:45
@epascarello The console give me an error: Uncaught TypeError: Cannot read property 'substr' of undefined at Object.success — BeginnerOne, Jul 19 '18 at 19:47
Okay now with that edit, so right there it is undefined so you are reading the property wrong.... `data.xxxxxxxx` is not defined. So debug what data is. `console.log(data)` — epascarello, Jul 19 '18 at 19:49
@epascarello I'm not sure what that means "so you are reading the property wrong" — BeginnerOne, Jul 19 '18 at 19:51
The property is undefined so that means `data` does not have what you think it does. Log the message, see what you have.... — epascarello, Jul 19 '18 at 19:52
@epascarello So I added: console.log(data) to my jquery function (just before the "var date..." and I get BeginDelayDateTime:"/Date(1531992480000)/" Which is the same value that I was getting in the alert. — BeginnerOne, Jul 19 '18 at 20:22
@epascarello You're exactly right. That was my error: typo. :-/ Thank you for your help. How should I mark the answer to this? — BeginnerOne, Jul 19 '18 at 20:42

score 1 · Answer 1 · answered Jul 20 '18 at 16:00

The problem was solved by correcting a typographical error. As epascarello pointed out BeginDelayDateTime != beginDelayDateTime. By correcting the misspelling, the issue was resolved an the Microsoft JSON date string is being parsed correctly. Many thanks to all who contributed their help.

javascript .substr breaks alert method

1 Answers1