if you want to use Power Query forget about Excel features and functions (sometimes they work sometimes not)
as you can see all dates are correct, doesn't matter they are in DMY or MDY format, bigger than other or not
here is solution for that:
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Filtered Rows", {{"Arrival", type datetime}}, "en-US"),
#"Changed Type with Locale1" = Table.TransformColumnTypes(#"Changed Type with Locale", {{"Departure", type datetime}}, "en-US"),
not text2columns
Bookmarks