Having a mix of MDY and DMY dates is definitely a problem. I don't know if I have any "magic" fixes. Comparing the file in post #90 with the file in post #24 and I notice that the file in post #90 has a mix of MDY and DMY dates, but the file in post #24 has all MDY dates.

from post #24
11/17/2022 12:23	11/17/2022 15:22
11/23/2022 19:22	11/24/2022 07:25
03/31/2022 15:04	04/01/2022 2:15           <- Note MDY for 1 April here but still text
04/01/2022 4:31	04/01/2022 12:40         <- Note MDY for 1 April here but still text
04/25/2022 21:01	04/26/2022 15:02
04/27/2022 12:42	04/27/2022 19:23
04/27/2022 19:23	04/28/2022 12:24
from post #90
11/17/2022  12:12	11/17/2022  15:22
11/23/2022 19:22	11/24/2022 07:25
03/31/2022 15:04	1/4/2022 02:15             <- Note DMY for 1 April here but still text
1/4/2022 04:31	1/4/2022 12:40                     <- Note DMY for 1 April here but still text
04/25/2022 21:01	04/26/2022 15:02
04/27/2022 12:42	04/27/2022 19:23
04/27/2022 19:23	04/28/2022 12:24
I would be asking myself where the data for post #24 came from and where the data for post #90 came from and then trying to figure out how I can always get the data from the same source that produced the data in post #24.

I did find a few dozen problems in the post #24 data. There are a few dozen timestamps with added parentheses and the time is in a 12 hour clock format rather than a 24 hour clock format. Find/Replace (Find what? extraneous character Replace with? nothing) can easily deal with the parentheses and the morning time stamps. The afternoon time stamps would require a little more work, but should be manageable. If I were going back to the source of the data, in addition to how to always get all MDY dates, I might also ask if there is any way to always get all 24 hour clock timestamps.