Comparing time and date values from strings and putting them in order

I have four arrays, each array contains date,time,info specified from a picker. I would like to find the item with the closest date and time out of all the items within the four arrays to the current date and time. Here’s a few example strings

”31.10.2022,01:00,Halloween”

“1.4.2023,00:00,April fools day”

Obviously halloween will come before April fools day judging by the date, even though the time is one hour behind. Ideally the code would check the date first and if they are the same then it would check the time.

0 Scarecrow123 over 4 years ago in reply to ronnywinkler

Lovely jubbly

0 Scarecrow123 over 4 years ago in reply to ronnywinkler

Also to get a specific bit of data such as the hour for comparison from “ts” would I do like

var t1 = ts.moment(:hour);?

or will as jim said the value number just be the necessary thing?

0 ronnywinkler over 4 years ago in reply to Scarecrow123

The moment object is a timestamp. So you need all possible values. Year, month, day, hour, minute.

From this you get a moment value (integer) representing the seconds since Unix epoch. These values you can compare (date1 > date2?).

0 Scarecrow123 over 4 years ago in reply to ronnywinkler

Aaaaaaah, I see now. Cool I have learned something today.

0 Scarecrow123 over 4 years ago in reply to ronnywinkler

Ooh one last question, the time amd dateformat required for inout depends on your personal settings yes?

0 ronnywinkler over 4 years ago in reply to Scarecrow123

I get this time string from a web API:
"2022-06-30T20:23:46.973Z"

So I read with substring the positions of the numbers.
I think you have to split the string at ".", "," and ":" if you dont have leading zeros in your date.

0 Scarecrow123 over 4 years ago in reply to ronnywinkler

Ok, I’ll have a test and see

0 Scarecrow123 over 4 years ago in reply to ronnywinkler

Ha ha it works!

P.S sorry for the awful pic quality and ignore the word BACK, that was a string from a prior test where I did not want to type a whole data and time out on a picker with just a mouse.

Now i’m going to save the datetiemstring that is newest under the t1>t2 if statement then draw it as text. This will become the snapshot view of my app which is all about reminders and alarms n such