Can't parse JSON data to .NET DateTime

Question

It's pretty simple. I have a string

string s = "/Date(1474408920000)/"

And I want to convert it to a date:

DateTime date = JsonConvert.DeserializeObject<DateTime>(s);

But I get the error:

"Error parsing comment. Expected: *, got D. Path '', line 1, position 1."

What's going on here?

Thanks for your help!

In JavaScript, anything between two '/' represents a regular expression. — itsme86
– itsme86, Commented Sep 23, 2016 at 21:03
You'll want to use Parse or tryparse... but first what date format is that? Epoch, Linux / Windows? mmssssDDmmyyyy ? — Austin T French
– Austin T French, Commented Sep 23, 2016 at 21:06

L.B · Accepted Answer · 2016-09-23 21:21:14Z

1

Your json string is not valid but can easily be fixed by surrounding it with "

string s = @"""/Date(1474408920000)/""";

Now DateTime date = JsonConvert.DeserializeObject<DateTime>(s); will work

answered Sep 23, 2016 at 21:21

L.B

116k20 gold badges189 silver badges229 bronze badges

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

1 Comment

Julian Wilson Over a year ago

Thanks. Very helpful. By the way, make sure you use .ToLocalTime() if you're trying to compare it to other DateTimes in your program!

Outshined · Accepted Answer · 2016-09-23 21:36:50Z

0

        var LogDate = new DateTime(2016, 9, 20, 22, 2, 0, DateTimeKind.Utc);

        string JsonDate = JsonConvert.SerializeObject(LogDate, new JsonSerializerSettings {
            DateFormatHandling = DateFormatHandling.MicrosoftDateFormat
        });

        Console.WriteLine(JsonDate);
        Console.ReadLine();

Output from this code gives you a proper JSON date format:

"\/Date(1474408920000)\/"

So your string should look like this:

string s = "\"\\/Date(1474408920000)\\/\"";

answered Sep 23, 2016 at 21:36

Outshined

7607 silver badges22 bronze badges

Comments

Vignesh.N · Accepted Answer · 2016-09-23 21:40:45Z

try serializing the DateTime obj to JSON using below code.

        var dateTime = DateTime.Now;
        var jsonDate = Newtonsoft.Json.JsonConvert.SerializeObject(dateTime, 
                            new Newtonsoft.Json.JsonSerializerSettings() { 
                                DateFormatHandling = Newtonsoft.Json.DateFormatHandling.MicrosoftDateFormat, 
                                DateParseHandling = Newtonsoft.Json.DateParseHandling.DateTime });

jsonDate would hold this value "\"\\/Date(1474408920000)\\/\"" or something in this format.
Now deserialize your json date string using below code.

var dateObj = Newtonsoft.Json.JsonConvert.DeserializeObject<DateTime>(dateString, 
                            new Newtonsoft.Json.JsonSerializerSettings() { 
                                DateParseHandling = Newtonsoft.Json.DateParseHandling.DateTime, 
                                DateFormatHandling = Newtonsoft.Json.DateFormatHandling.MicrosoftDateFormat });

Collectives™ on Stack Overflow

Can't parse JSON data to .NET DateTime

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related