How to extract exact date from following json string in jquery

Question

public class Plans
    {
        public long PlanID { get; set; }

        public long? CompanyID { get; set; }

        public string PlanType { get; set; }

        public string PlanName { get; set; }        

        public bool? IsActive { get; set; }

        public int? CreatedBy { get; set; }

        public DateTime? CreatedDate { get; set; }       

        public int? CheckedBy { get; set; }            
    }              

    var date = [{
          0:
            BusinessType: "null"
            CheckedBy: null
            CheckedDate: null
            CompanyID: null
            CompanyName: "Swastik"
            CreatedBy: null
            CreatedDate: "/Date(1587383258707)/"    
        }];

Added Controller Method and ajax call from view for better assistance.Unable to find the way to do it. I am not able to find out how to extract date from above json string retrieved in jquery. Kindly assist me in that. Added my model class above that I am using. I am simply getting data by calling a procedure and rendering the data from controller to view using ajax call and populating the ajax call sucess data in controls.

This doesn't look like a valid object.. there is a key `0` without any value. Also, this is an array, not a JSON string. Please post the correct code and update your description accordingly. — palaѕн, Apr 23 '20 at 08:39
Once you've fixed that this is likely a duplicate: https://stackoverflow.com/questions/726334/asp-net-mvc-jsonresult-date-format — Rory McCrossan, Apr 23 '20 at 08:43

score 1 · Accepted Answer · answered Apr 23 '20 at 08:52

1

An alternative Approach, what I do is create another property/ function in my Model.

your model in asp

    public class YourModel{
       public DateTime CreatedDate {get;set;}
        // if you want through model
        public string FormattedCreatedDate {get { return CreatedDate.ToString("dd-MM-yyyy");}} 
        // or through functions
        public string GetFormattedCreatedDate(){
            return CreatedDate.ToString("dd-MM-yyyy");
        }
    }

answered Apr 23 '20 at 08:52

Josh

223
1
6

I am showing this date in label text in my view directly after extracting from above json – jiga Apr 23 '20 at 08:59
Isn't this from an ajax call? – Josh Apr 23 '20 at 09:14
yes result is coming from ajax call and after getting I am populating the html to label – jiga Apr 23 '20 at 09:22
Can you add your controller method? – Josh Apr 23 '20 at 09:24
okay, I assume UsersBal is a Model? public class UsersBal, add public string FormattedCreatedDate {get { return CreatedDate.ToString("dd-MM-yyyy");}} as one of the properties. then see your result again. there should be a FormattedCreatedDate property there. Use that to fill your label. – Josh Apr 23 '20 at 09:33
getting error No overload for Method ToString takes 1 Parameter – jiga Apr 23 '20 at 10:30
can I see the model UsersBal? – Josh Apr 23 '20 at 10:33
Added my model class above – jiga Apr 23 '20 at 10:44
1

nullable DateTime, try adding public string FormattedCreatedDate {get { return CreatedDate.Value.ToString("dd-MM-yyyy");}} – Josh Apr 23 '20 at 11:19
Thanks it worked for me. Thanks for saving my time. @Josh – jiga Apr 23 '20 at 11:28

How to extract exact date from following json string in jquery

1 Answers1