Get the difference between dates in terms of weeks, months, quarters, and years

by

what about this:

# get difference between dates `"01.12.2013"` and `"31.12.2013"`

# weeks
difftime(strptime("26.03.2014", format = "%d.%m.%Y"),
strptime("14.01.2013", format = "%d.%m.%Y"),units="weeks")
Time difference of 62.28571 weeks

# months
(as.yearmon(strptime("26.03.2014", format = "%d.%m.%Y"))-
as.yearmon(strptime("14.01.2013", format = "%d.%m.%Y")))*12
[1] 14

# quarters
(as.yearqtr(strptime("26.03.2014", format = "%d.%m.%Y"))-
as.yearqtr(strptime("14.01.2013", format = "%d.%m.%Y")))*4
[1] 4

# years
year(strptime("26.03.2014", format = "%d.%m.%Y"))-
year(strptime("14.01.2013", format = "%d.%m.%Y"))
[1] 1

as.yearmon() and as.yearqtr() are in package zoo. year() is in package lubridate.
What do you think?

More Related Contents:

  1. Transform year/week to date object
  2. Looping over a Date or POSIXct object results in a numeric iterator
  3. Axis labels on two lines with nested x variables (year below months)
  4. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  5. How to change multiple Date formats in same column?
  6. How to get week numbers from dates?
  7. Extract month and year from a zoo::yearmon object
  8. How to get a vertical geom_vline to an x-axis of class date?
  9. How to subtract/add days from/to a date?
  10. Formatting dates with scale_x_date in ggplot2
  11. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  12. Split date into different columns for year, month and day
  13. Convert a numeric month to a month abbreviation
  14. Converting Date formats in R [closed]
  15. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  16. Convert four digit year values to class Date
  17. Convert string to date, format: “dd.mm.yyyy”
  18. Add (subtract) months without exceeding the last day of the new month
  19. Convert yyyymmdd string to Date class in R
  20. Format date as Year/Quarter
  21. Converting a character string into a date in R
  22. Checking if Date is Between two Dates in R
  23. R: How to get the Week number of the month
  24. Create end of the month date from a date variable
  25. Subset data.frame by date
  26. Convert Factor to Date/Time in R
  27. How to convert a date from a character string?
  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