Convert string to date, format: “dd.mm.yyyy”

by

The format is case-sensitive (“%y” is ambiguous and system dependent, I believe): 

as.Date(D, "%d.%m.%Y")
[1] "1948-12-06"

The help topic ?strptime has details: 

 ‘%y’ Year without century (00-99).  On input, values 00 to 68 are
      prefixed by 20 and 69 to 99 by 19 - that is the behaviour
      specified by the 2004 and 2008 POSIX standards, but they do
      also say ‘it is expected that in a future version the default
      century inferred from a 2-digit year will change’.

More Related Contents:

  1. Convert date-time string to class Date
  2. How to convert Excel date format to proper date in R
  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. Get the difference between dates in terms of weeks, months, quarters, and years
  7. Converting year and month (“yyyy-mm” format) to a date?
  8. How to flatten / merge overlapping time periods
  9. Number of months between two dates
  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. Add a month to a Date [duplicate]
  14. Convert integer to class Date
  15. as.Date returning NA while converting from ‘ddmmmyyyy’
  16. R: How to handle times without dates?
  17. Extract Month and Year From Date in R
  18. Extracting time from POSIXct
  19. Format for ordinal dates (day of month with suffixes -st, -nd, -rd, -th)
  20. How can I fix corrupted dates in R?
  21. How to sort a data frame by date
  22. Convert yyyymmdd string to Date class in R
  23. Subsetting a dataframe for a specified month and year
  24. R group by date, and summarize the values
  25. Converting a character string into a date in R
  26. format year-month to POSIXct [duplicate]
  27. Convert integer as “20160119” to different columns of “day” “year” “month”
  28. change a column from birth date to age in r
  29. Convert two-digit years to four-digit years with correct century
  30. Create a Vector of All Days Between Two Dates

Leave a Comment