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…

Sorting JSON array by date

Anil_G (Anil Gorthi) February 18, 2025, 5:47pm 13

please try this

jarr_events.OrderBy(function(x) DateTime.ParseExact(x("loggedDate").ToString,"yyyy-MM-dd HH:mm:ss.fff",System.Globalization.CultureInfo.InvariantCulture)).FirstOrDefault().ToObject(Of JObject)

cheers

Topic		Replies	Views
Get the latest item in the JSON array Studio studio , question , activities_panel	9	549	April 27, 2023
How Can I Sort JArray For Value Help	5	4555	October 26, 2021
Sort array of Date Time in descending order Activities activities , question , script	3	3608	April 7, 2022
Sort an Array of Strings containing Dates by Date Help activities , question , data_manipulation	4	4018	December 7, 2019
Compare Array of strings to return the latest date then find the index with in the array Activities uiautomation , activities , studio , array , string-array , arrays	4	1770	February 26, 2023

Sorting JSON array by date

Related topics