how-to-change-date-format-from-from-mm-dd-YYYY -to-dd-mm-YYYY

Ekopalypse

your explanation confuses me.
Let’s take this simple dates

21/10/2021
26/7/2020
17/12/2021

How do you want it to be sorted?

Lorenzo Atom

@Ekopalypse
i give part of my actual data:

5/17/2033 8:59:58 AM
8/19/2033 10:59:58 AM
11/18/2033 7:59:58 PM
2/15/2034 9:59:58 AM
5/17/2034 2:59:58 PM
8/19/2034 4:59:58 PM
11/19/2034 1:59:58 AM
2/15/2035 3:59:58 PM
5/17/2035 8:59:57 PM
8/19/2035 9:59:57 PM
11/19/2035 6:59:57 AM
2/15/2036 9:59:57 PM
5/17/2036 1:59:57 AM
8/19/2036 3:59:57 AM
11/18/2036 12:59:57 P
2/15/2037 2:59:57 AM
5/17/2037 7:59:57 AM
8/19/2037 9:59:57 AM
11/18/2037 6:59:57 PM
2/15/2038 8:59:57 AM
5/17/2038 1:59:57 PM
8/19/2038 3:59:57 PM
11/19/2038 12:59:57 A
2/15/2039 2:59:57 PM
5/17/2039 7:59:57 PM
8/19/2039 9:59:57 PM
11/19/2039 6:59:57 AM
2/15/2040 8:59:57 PM
5/17/2040 1:59:57 AM
8/19/2040 3:59:57 AM
11/18/2040 12:59:57 P
2/15/2041 2:59:57 AM
5/17/2041 6:59:57 AM
8/19/2041 8:59:57 AM
11/18/2041 5:59:57 PM
2/15/2042 8:59:57 AM
5/17/2042 12:59:57 PM
8/19/2042 2:59:57 PM
11/18/2042 11:59:57 P
2/16/2018 327.264696
5/17/2018 5:59.59 PM
8/19/2018 7:59.59 PM
11/19/2018 3:59.59 AM
2/15/2019 6:59:59 PM
5/17/2019 11:59:59 PM
8/20/2019 1:59:59 AM
11/19/2019 9:59:59 AM
2/15/2020 11:59:59 PM
5/17/2020 5:59:59 AM
8/19/2020 6:59:59 AM
11/18/2020 3:59:59 PM
2/15/2021 5:59.59 AM
5/17/2021 10:59:59 AM
8/19/2021 12:59:59 PM
11/18/2021 9:59:59 PM
2/15/2022 11:59:59 AM
5/17/2022 4:59:59 PM
8/19/2022 6:59:59 PM
11/19/2022 3:59:59 AM
2/15/2023 5:59.59 PM
5/17/2023 10:59:59 PM
8/20/2023 12:59:59 AM
11/19/2023 9:59:59 AM
2/15/2024 11:59:59 PM
9/17/2024 4:59:59 AM
8/19/2024 6:59:59 AM
11/18/2024 2:59:59 PM
2/15/2025 5:59:59 AM
5/17/2025 10:59:59 AM
8/19/2025 11:59:59 AM
11/18/2025 8:59:59 PM
2/15/2026 10:59:59 AM
5/17/2026 3:59:59 PM
8/19/2026 5:59:59 PM
11/19/2026 2:59:58 AM
2/15/2027 4:59:58 PM
5/17/2027 9:59:58 PM
8/19/2027 11:59:58 PM
11/19/2027 8:59:58 AM
2/15/2028 10:59:58 PM
5/17/2028 3:59:58 AM
8/19/2028 5:59:58 AM
11/18/2028 2:59:58 PM
2/15/2029 4:59:58 AM
5/17/2029 9:59:58 AM
8/19/2029 11:59:59 AM
11/18/2029 7:59:58 PM
2/15/2030 10:59:58 AM
5/17/2030 3:59:598 PM
8/19/2030 4:59:58 PM
11/19/2030 1:59:58 AM
2/15/2031 3:59:58 PM
5/17/2031 8:59:58 PM
8/19/2031 10:59:58 PM
11/19/2031 7:59:58 AM
2/15/2032 9:59:58 PM
5/17/2032 2:59:58 AM
8/19/2032 4:59:58 AM
11/18/2032 1:59:58 PM
2/15/2033 3:59:58 AM

this data cannot be edited… so we have month / day / year…
i wish i could sort this in date / month / year
Thanks

Lorenzo Atom

@Lorenzo-Atom said in how-to-change-date-format-from-from-mm-dd-YYYY -to-dd-mm-YYYY:

@Ekopalypse
i give part of my actual data:

5/17/2033 8:59:58 AM
8/19/2033 10:59:58 AM
11/18/2033 7:59:58 PM
2/15/2034 9:59:58 AM
5/17/2034 2:59:58 PM
8/19/2034 4:59:58 PM
11/19/2034 1:59:58 AM
2/15/2035 3:59:58 PM
5/17/2035 8:59:57 PM
8/19/2035 9:59:57 PM
11/19/2035 6:59:57 AM
2/15/2036 9:59:57 PM
5/17/2036 1:59:57 AM
8/19/2036 3:59:57 AM
11/18/2036 12:59:57 P
2/15/2037 2:59:57 AM
5/17/2037 7:59:57 AM
8/19/2037 9:59:57 AM
11/18/2037 6:59:57 PM
2/15/2038 8:59:57 AM
5/17/2038 1:59:57 PM
8/19/2038 3:59:57 PM
11/19/2038 12:59:57 A
2/15/2039 2:59:57 PM
5/17/2039 7:59:57 PM
8/19/2039 9:59:57 PM
11/19/2039 6:59:57 AM
2/15/2040 8:59:57 PM
5/17/2040 1:59:57 AM
8/19/2040 3:59:57 AM
11/18/2040 12:59:57 P
2/15/2041 2:59:57 AM
5/17/2041 6:59:57 AM
8/19/2041 8:59:57 AM
11/18/2041 5:59:57 PM
2/15/2042 8:59:57 AM
5/17/2042 12:59:57 PM
8/19/2042 2:59:57 PM
11/18/2042 11:59:57 P
2/16/2018 327.264696
5/17/2018 5:59.59 PM
8/19/2018 7:59.59 PM
11/19/2018 3:59.59 AM
2/15/2019 6:59:59 PM
5/17/2019 11:59:59 PM
8/20/2019 1:59:59 AM
11/19/2019 9:59:59 AM
2/15/2020 11:59:59 PM
5/17/2020 5:59:59 AM
8/19/2020 6:59:59 AM
11/18/2020 3:59:59 PM
2/15/2021 5:59.59 AM
5/17/2021 10:59:59 AM
8/19/2021 12:59:59 PM
11/18/2021 9:59:59 PM
2/15/2022 11:59:59 AM
5/17/2022 4:59:59 PM
8/19/2022 6:59:59 PM
11/19/2022 3:59:59 AM
2/15/2023 5:59.59 PM
5/17/2023 10:59:59 PM
8/20/2023 12:59:59 AM
11/19/2023 9:59:59 AM
2/15/2024 11:59:59 PM
9/17/2024 4:59:59 AM
8/19/2024 6:59:59 AM
11/18/2024 2:59:59 PM
2/15/2025 5:59:59 AM
5/17/2025 10:59:59 AM
8/19/2025 11:59:59 AM
11/18/2025 8:59:59 PM
2/15/2026 10:59:59 AM
5/17/2026 3:59:59 PM
8/19/2026 5:59:59 PM
11/19/2026 2:59:58 AM
2/15/2027 4:59:58 PM
5/17/2027 9:59:58 PM
8/19/2027 11:59:58 PM
11/19/2027 8:59:58 AM
2/15/2028 10:59:58 PM
5/17/2028 3:59:58 AM
8/19/2028 5:59:58 AM
11/18/2028 2:59:58 PM
2/15/2029 4:59:58 AM
5/17/2029 9:59:58 AM
8/19/2029 11:59:59 AM
11/18/2029 7:59:58 PM
2/15/2030 10:59:58 AM
5/17/2030 3:59:598 PM
8/19/2030 4:59:58 PM
11/19/2030 1:59:58 AM
2/15/2031 3:59:58 PM
5/17/2031 8:59:58 PM
8/19/2031 10:59:58 PM
11/19/2031 7:59:58 AM
2/15/2032 9:59:58 PM
5/17/2032 2:59:58 AM
8/19/2032 4:59:58 AM
11/18/2032 1:59:58 PM
2/15/2033 3:59:58 AM

this data cannot be edited… so we have month / day / year…
i wish i could sort this in date / month / year
Thanks

When i say cannot be edited i mean that this FORMAT month / day / year came from another program where i cannot do anything so the starting point is month / day / year i wish i could have ------> day / month/ year… i hope i clarify i bit sorry for my english… i am italian… Thanks

Lorenzo Atom

This post is deleted!

Ekopalypse

@Lorenzo-Atom

thx for the data, but my question is still open

21/10/2021
26/7/2020
17/12/2021

How do you want it to be sorted?

i am italian…

If I would have taken my lessons more seriously we could do this in Italian but at that time I was just a lazy … :-)

Lorenzo Atom

@Ekopalypse
something like this…
2019.0811
2020.0111
2020.0426
2020.0511
2020.0513
2020.0515
2020.0618
2020.0623
2020.0624
2020.0712
2020.0726
!!!2020
2020.0728
2020.0910
2020.0912
2020.0928
2020.1004
2020.1014
2020.1104
2020.1114
2020.1119
(2020.112
!!!2
2020.1206
2020.1129
2020.1217
2020.1230
2021.0103
2021.0114
(2021.012
2021.01.2
2021.0131
2021.0221
2021.0312
2021.0326
2021.0428
2021.0523
2021.0530
2021.0621
2021.0623
2021.0626
2021.0708
2021.0820
2021.0927
2021.1007
2021.1011
2021.1018
2021.1019
2021.1102
2021.1122
2021.1201
2021.1219
2021.1229
2021.1231
2022.0114
2022.0119
2022.0125
2022.0129
2022.0204
2022.0223
2022.0228
2022.0331
2022.0430
2022.0510
2022.0603
2022.0605
2022.0617
2022.0628
2022.0729
2022.0824
2022.0910
2022.1002
2022.1009
2022.1016
2022.1023
2022.1031
2022.1123
2022.1124
2022.1204
2022.1229
2023.0109
2023.0113
2023.0119
2023.0123
2023.0127
2023.0205
2023.0208
2023.0312
2023.0404
2023.0421
2023.0502
2023.0515
2023.0530
2023.0618
2023.0701
2023.0723
2023.0824
2023.0829
2023.0904
2023.0905
2023.0916
2023.0929
2023.1005
2023.1011
2023.1104
2023.1125
2023.1206
2023.1213
2023.1231
2024.0102
2024.0120
2024.0121
2024.0127
2024.0130
2024.0314
2024.0402
2024.0407
2024.0426
2024.0503
2024.0512
2024.0630
2024.0702
2024.0805
2024.0829
2024.0902
2024.0911
2024.1009
2024.1012
2024.1116
2024.1126
2024.1126
2024.1207
2024.1208
2024.1216
2025.0102
2025.0131
2025.0131
2025.0201
2025.0204
2025.0224
2025.0302
2025.0315
2025.0407
2025.0412
2025.0413
2025.0421
2025.0425
2025.0428
2025.0504
2025.0514
2025.0705
2025.0713
2025.0718
2025.0811

the important is that the first check woult be day then month then year… so cronologically…like a calendar…
if you put europen or Us does not matter, but that today must be today!!! haha ))) thanks

Ekopalypse

ok, this means you have a 3 step process, probably it can be recorded as a macro.

Step 1 - Convert the format into YEAR/MONTH/DAY
find: ^(\d{1,2})/(\d{1,2})/(\d{4})
replace: $3/$1/$2

Step2: - Sort
Edit->Line operations->Sort lines as integer ascending

Step 3: optional, convert date format back to original
find: ^(\d{4})/(\d{1,2})/(\d{1,2})
replace: $2/$3/$1

Lorenzo Atom

@Ekopalypse said in how-to-change-date-format-from-from-mm-dd-YYYY -to-dd-mm-YYYY:

$3/$1/$2

Seems it works…is in american format… the lst step you give me after i already sort, how can be day/month/year?
Amazing thanks in advance REALLY… REALLY REALLY… is an output of years of studyings… thanks again

Ekopalypse

@Lorenzo-Atom

$2, $3 and $1 refer to the respective groups
captured by (\d{4})/(\d{1,2})/(\d{1,2})
The () is what makes a group, so $1
refers to what has matched by (\d{4}), $2 the next
group and $3 the last group.

Rearrange the $X in $2/$3/$1 and you will see how it will change.

Lorenzo Atom

@Ekopalypse said in how-to-change-date-format-from-from-mm-dd-YYYY -to-dd-mm-YYYY:

$2, $3 and $1 refer to the respective groups
captured by (\d{4})/(\d{1,2})/(\d{1,2})
The () is what makes a group, so $1
refers to what has matched by (\d{4}), $2 the next
group and $3 the last group.
Rearrange the $X in $2/$3/$1 and you will see how it will change.

Was REALLY a pleasure… thanks really …REALLY Appreciate!