Forum Discussion
sorting date column oldest to newest
I imported a csv file of my connections from linkedin and I want to sort them by the date we connected.
Even though I mark the whole column (F) to be a date column, so they become date cells (align...
Hi,
It's been a while since the topic, but the solution that I created may be useful for those who cannot solve the problem.
Dates in a column can be sorted easily from oldest to newest in other column by getting records from Adodb.Recordset :
rs.Open sorgu, con, 1, 1
Range("K3").CopyFromRecordset rs
https://eksi30.com/vba-filter-between-two-dates-with-userform/
I have a much simpler solution. I still couldn't get option of 'newest to oldest' to appear in Sort, after following steps above to use 'Text to Column' on data tab, and setting number format in column to date dd/mm/yyyy.
So instead I changed date format to yyyy-mm-dd and then I could use 'sort ascending' in the sort function to get my dates from newest to oldest.
So instead I changed date format to yyyy-mm-dd and then I could use 'sort ascending' in the sort function to get my dates from newest to oldest.