How to convert date from mm/dd/YYYY to dd/mm/YYYY in R?

Question

Let's say for instance I am having a very huge amount of dataset with millions of columns. One of the column has Dates such as "3/28/2020" (mm/dd/YYYY) format.

For my analysis, I need a format (dd/mm/YYYY)

How can I do that?

Answer 1

In R programming, you can easily convert to standard date class and then use format to get data in desired format.

format(as.Date('3/28/2020', '%m/%d/%Y'), '%d/%m/%Y')

#[1] "28/03/2020"