Suppose you have a character column containing text like “May 1, 2023”
And try to convert it to date from the column menu.
This ends up with incorrect results like “2023-01-20”.
If this is the case, then select the locale “English_United States” as follows, and it shows the correct result “2023-05-01”