Convert JSON.NET date to jQuery UI Datepicker format

Question

I am serializing and passing a date out of my controller using JsonConvert.SerializeObject and sending it to a jQuery UI Datepicker field. Right now the output is like "2015-12-05T00:00:00" and I want it to be in a format of MM/DD/YYYY. My output is available via the AJAX returned data object data.BoardStart and is being attached to #BoardStart but always shows as 12/31/1969.

I've tried moment (and failed) using this code:

var BoardStart = data.BoardStart;
$("#BoardStart").val(moment(BoardStart).format('MM/DD/YYYY'));

Any suggestions? Thanks!

user2314737 · Accepted Answer · 2015-05-28 16:40:40Z

2

Using the moment.js library for formatting date, substitute

moment(BoardStart).format('MM/DD/YYYY')

with

moment(BoardStart, "YYYY-MM-DDhh:mm:ss").format("MM/DD/YYYY")

answered May 28, 2015 at 16:40

user2314737

29.7k20 gold badges109 silver badges126 bronze badges

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

1 Comment

Matt Johnson-Pint Over a year ago

The ISO format is supported by default, so this shouldn't have made any difference. See "Supported ISO 8601 strings" under this part of the docs. Also, you are missing the T, but that wouldn't make a difference either.

loli · Accepted Answer · 2015-05-28 16:39:07Z

1

You can build it like this

var date1 = "2015-12-05T00:00:00";
date1.replace('T',' ');
var date2 = new Date(date1);
var yyyy = date2.getFullYear().toString();
var mm = (date2.getMonth()+1).toString();
var dd  = date2.getDate().toString();
var finaldate = mm+'/'+dd+'/'+yyyy;

answered May 28, 2015 at 16:39

loli

1,0688 silver badges14 bronze badges

1 Comment

Matt Johnson-Pint Over a year ago

A couple of issues with this approach: 1) you'd need to zero-pad the mm and dd values. 2) the Date object might parse it as UTC instead of local time, which could throw it a day earlier depending on time zone. moment is much safer.

Vsh · Accepted Answer · 2016-07-26 20:56:13Z

-1

$("#BoardStart").datepicker("setDate", new Date(data.BoardStart));

answered Jul 26, 2016 at 20:56

Vsh

671 silver badge2 bronze badges

Collectives™ on Stack Overflow

Convert JSON.NET date to jQuery UI Datepicker format

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related