Converting Date formats in R [closed]

by

Good practice is to store date in R as YYYY-MM-DD, and your strings already seem to be at the good format, but :

The format you’re passing to as.Date must describe what the strings contain, not what you’re expecting as an output.

"%d/%b/%Y" stands for “day as a number (0-31) slash abbreviated month slash 4-digit year”, and your strings format are “4-digit year – month as a number – day as a number”.

If you want to format the date, you need to call format :

> date <- "2016-01-01"
> date <- as.Date(date, format = "%Y-%m-%d")
> date
[1] "2016-01-01"
> format(date, "%d/%b/%Y")
[1] "01/jan/2016"

More Related Contents:

  1. How to prevent ifelse() from turning Date objects into numeric objects
  2. Convert date-time string to class Date
  3. How to convert variable with mixed date formats to one format?
  4. Find the day of a week
  5. Specify custom Date format for colClasses argument in read.table/read.csv
  6. Converting year and month (“yyyy-mm” format) to a date?
  7. Changing date format in R
  8. Number of months between two dates
  9. Split date-time column into Date and time variables
  10. Subset a dataframe between 2 dates
  11. Find which season a particular date belongs to
  12. as.Date with dates in format m/d/y in R
  13. Generate a sequence of the last day of the month over two years
  14. as.Date returning NA while converting from ‘ddmmmyyyy’
  15. R: How to handle times without dates?
  16. Extract Month and Year From Date in R
  17. Extracting time from POSIXct
  18. Format for ordinal dates (day of month with suffixes -st, -nd, -rd, -th)
  19. How can I fix corrupted dates in R?
  20. How to sort a data frame by date
  21. Converting date in Year.decimal form in R
  22. How to subtract years?
  23. Subsetting a dataframe for a specified month and year
  24. R group by date, and summarize the values
  25. format year-month to POSIXct [duplicate]
  26. Convert integer as “20160119” to different columns of “day” “year” “month”
  27. Get date difference in years (floating point)
  28. set date range in ggplot
  29. Create a Vector of All Days Between Two Dates
  30. Using geom_rect for time series shading in R

Leave a Comment