format json.net date using jQuery

Question

I have got the following dates (shown using HTML) from JSON.NET.

<span class="date"> 2013-01-01T00:00:00  </span>
<span class="date"> 2009-05-01T00:00:00  </span>
<span class="date"> 2011-01-06T00:00:00  </span>
<span class="date"> 2012-03-09T00:00:00  </span>

How can I covenrt these dates to the format 'mm-dd-yyyy'. That means, the HTML should be like this:

<span class="date"> 01-01-2013  </span>
<span class="date"> 05-01-2009  </span>
<span class="date"> 01-06-2011  </span>
<span class="date"> 03-09-2012  </span>

I tried several ways using jQuery DatePicker and DateFormat. I also got similar questions on SO. But still I coudn't figure this out. Any help will be greatly appreciated.

Matt Zeunert · Accepted Answer · 2013-01-18 18:18:02Z

2

jQuery UI datepicker.parseDate can't parse times, so you'll have to remove them:

var input = "2013-01-01T00:00:00";
input = input.split("T")[0]; // "2013-01-01"
var date = $.datepicker.parseDate("yy-mm-dd", input);

Then using formatDate shouldn't be a problem:

var newDateString = $.datepicker.formatDate("mm-dd-yy", date);

To get the span html:

var spanHtml = "<span class='date'> " + newDateString + " </span>";

edited Jan 18, 2013 at 18:18

answered Jan 18, 2013 at 0:38

Matt Zeunert

16.6k7 gold badges56 silver badges83 bronze badges

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

1 Comment

N Rocking Over a year ago

How can I get this output <span class="date"> 01-01-2013 </span> after using formatDate?

Ram · Accepted Answer · 2013-01-18 00:39:44Z

1

$('span').text(function(i, v){
   var d = new Date($.trim(v));
   return (d.getMonth()+1) + '-' + d.getDate() + '-' + d.getFullYear();
});

http://jsfiddle.net/BdMfp/

answered Jan 18, 2013 at 0:39

Ram

145k16 gold badges174 silver badges201 bronze badges

2 Comments

N Rocking Over a year ago

It cannot convert correctly. E.g. the date'2014-01-01T00:00:00' converts to 12-31-2013.

N Rocking Over a year ago

I tested it using my ASP.NET website and using your link. Both websites show earlier dates. I am running Chrome on XP.

Collectives™ on Stack Overflow

format json.net date using jQuery

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related