date format not correct when pulling from database using linq query

Question

I want to pull a date from db and display it in a telerik ddl. I am able to pull the date and display it, but cant get the formatting to work. The date is display like this:

/Date(13496724000000)/

Here is my Controller action to pull the date from db:

    [HttpPost]
    public ActionResult Date(int id)
    {
        var dates = (from p in db.vwdb.Where(u => u.Id == id)
                           group p by p.Date into g
                    select g.Key).ToList();

        return Json(new { data = Convert.ToDateTime(weeks.Min())});
    }

Here is my jquery to display it in ddl:

function populateDate() {
    var link = '/Users/Date';
    var dataSource = [];
    $.ajax({
        type: 'POST',
        url: link,
        data: { id: id },
        dataType: 'json',
        success: function (result) {
                var dateOf = result.data;
                dataSource.push({ Text: dateOf , Value: dateOf });
            $("#Date").data("tDropDownList").dataBind(dataSource);
        },
        error: function (result) {
            alert(result.message);
        }
    });
};

I want to display the date in this format: "MM/DD/YYYY" instead of "/Date(13496724000000)/"

Any help is much appreciated.

and where do you use dates list?

Hamlet Hakobyan
– Hamlet Hakobyan

2012-10-29 20:56:28 +00:00
Commented Oct 29, 2012 at 20:56 — Hamlet Hakobyan
– Hamlet Hakobyan, Commented Oct 29, 2012 at 20:56
@HamletHakobyan use it to display dates on a web page.

user793468
– user793468

2012-10-29 21:08:45 +00:00
Commented Oct 29, 2012 at 21:08 — user793468
– user793468, Commented Oct 29, 2012 at 21:08
Is moment.js something for you?

Gert Arnold
– Gert Arnold

2012-10-30 12:35:50 +00:00
Commented Oct 30, 2012 at 12:35 — Gert Arnold
– Gert Arnold, Commented Oct 30, 2012 at 12:35

Arun Manjhi · Accepted Answer · 2012-10-30 11:17:24Z

2

You can Parse this json Date format and convert it into "MM/DD/YYYY" format.

Try:

// jsonDate = "/Date(13496724000000)/"

function parseJsonDateTime(jsonDate) {

    var dateString = jsonDate.substr(6);
    var currentTime = new Date(parseInt(dateString));
    var month = currentTime.getMonth();
    var day = currentTime.getDate();
    var year = currentTime.getFullYear();

   var date = month + "/" + day + "/" + year;
    return date;

};

answered Oct 30, 2012 at 11:17

Arun Manjhi

1739 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Darin Dimitrov · Accepted Answer · 2012-10-30 07:07:13Z

1

Try like this:

success: function (result) {
    var date = new Date(parseInt(result.data.replace("/Date(", "").replace(")/",""), 10));
    var dateOf = date.getDate() + "/" + (date.getMonth() + 1) + "/" + date.getFullYear();
    dataSource.push({ Text: dateOf , Value: dateOf });
    $("#Date").data("tDropDownList").dataBind(dataSource);
}

answered Oct 30, 2012 at 7:07

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

Collectives™ on Stack Overflow

date format not correct when pulling from database using linq query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related