Please help me to sort the Json array based the date. Please see below input data. The out put should come the latest date item should be on top. I have tried this one but its throwing the exception
eventsJsarray.Cast(Of JObject).Where(Function (x) x(“event”).toString).OrderByDescending(function(x) Cdate(x(“loggedDate”).ToString)).FirstOrDefault
"event": [
{
"agnNumber": "123456",
"agnName": "Mathew",
"City": "Chennai",
"loggedDate": "2025-01-26 09:45:49.926",
},
{
"agnNumber": "123768",
"agnName": "enraled",
"City": "hyd",
"loggedDate": "2025-01-25 09:45:49.926",
},
{
"agnNumber": "123458",
"agnName": "Mathew",
"City": "bnglr",
"loggedDate": "2024-01-24 09:45:49.926",
},
{
"agnNumber": "123458",
"agnName": "Mathew",
"City": "mubai",
"loggedDate": "2025-01-27 09:45:49.926",
}
]