Good morning

I have an shop order list where the rows are fetched from a RestAPI providing a JSON containing the orderid, name, address and orderdate...

Now how can I generate sections for the list grouped by the order date in JSON? The JSON returned is already sorted descending by order id..so are the dates...

thanks for any hints richard

Although this is for Core Data, the principles are the same and you could use a similar approach.

Grouping in sections

The JSON specification does not specify a format for exchanging dates which is why there are so many different ways to do it. JSON does not know anything about dates. What .NET does is a non-standard hack/extension. The problem with JSON date and really JavaScript in general – is that there’s no equivalent literal representation for dates. In JavaScript following Date constructor straight away converts the milliseconds since 1970 to Date as follows:

var jsonDate = new Date(1297246301973);

Then let’s convert it to js format:

var date = new Date(parseInt(jsonDate.substr(6)));

The substr() function takes out the /Date( part, and the parseInt() function gets the integer and ignores the )/ at the end. The resulting number is passed into the Date constructor .

For ISO-8601 formatted JSON dates, just pass the string into the Date constructor:

var date = new Date(jsonDate);