Currently, I have imported data into R with fread and the import works perfectly. However, for 2 columns the date is read in as “d.m.Y” and saved as a character. The problem is that the columns should be in date format and in the following format “Y-m-d”. I just can’t get these columns to be adjusted accordingly…

**# Function for standardizing the date format**
standardize_date_format <- function(df) {
  date_columns <- c("Column1", "Column2")
  for (col in date_columns) {
    if (col %in% names(df)) {
      df[[col]] <- parse_date_time(df[[col]], orders = c("dmy", "mdy", "ymd"))
    }
  }
  return(df)
}

** # Standardize the date format in the data frame**
data.frame <- standardize_date_format(old)