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



  • @Lorenzo-Atom

    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?



  • @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 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



  • This post is deleted!


  • @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 … :-)



  • @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



  • 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



  • @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



  • @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.



  • @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!


Log in to reply