I have a data set were some of the dates in UK format and others are in US Format
6/28/2019 07/01/2019
6/28/2019 07/01/2019
6/28/2019 07/01/2019
6/28/2019 07/01/2019
6/28/2019 07/01/2019
what would be the best way to convert them all into the standard UK format
Without seeing your data, I do believe all your dates are in the same format actually,
mm/dd/yyyy
. I have not seen any dataset that deliberately would mix two formats together. Some of the dates just happen to be legal dates in your UK version, e.g.: 7-1-2019 can be both 7th of january but most likely is meant to be 1st of july.One of the easiest way to quickly convert these dates is to:
Date
formatMYD