I have a SQLite query that fills a listbox with 5 columns in ASC order from that query
Please excuse some of the dates as I just populated a listbox for display purposes
What I want to do is sort the listbox based on column 0, the “Operation Number” column.
The first 2 digits are for the year and the last 3 after the “-” are for the job number. Of course if I sort Ascending it will start at “00-XXX” down to “99-XXX” or if Descending it would sort “99-XXX” to “00-XXX”
What I would like is to have the listbox show the current year “19” first then “18” , “17” etc.
I’m not using CompareRows as I’m not allowing the user to click the header for custom sorting
Thought of using an array of years and trying to sort from that but figured I would ask those smarter then me what they might try
I thought about using the SQL Date/Time but that is not always guaranteed to be there plus some jobs are closed and some are open