Generate a sequence of the last day of the month over two years

by

Yes, you found the correct trick: going back a day from the first of the next month.

Here is as a one-liner in base R:

R> seq(as.Date("2010-02-01"), length=24, by="1 month") - 1
 [1] "2010-01-31" "2010-02-28" "2010-03-31" "2010-04-30" "2010-05-31"
 [6] "2010-06-30" "2010-07-31" "2010-08-31" "2010-09-30" "2010-10-31"
[11] "2010-11-30" "2010-12-31" "2011-01-31" "2011-02-28" "2011-03-31"
[16] "2011-04-30" "2011-05-31" "2011-06-30" "2011-07-31" "2011-08-31"
[21] "2011-09-30" "2011-10-31" "2011-11-30" "2011-12-31"
R>

So no need for lubridate which (while being a fine package) isn’t needed for simple task like this. Plus, its overloading of existing base functions still strikes me as somewhat dangerous…

More Related Contents:

  1. Transform year/week to date object
  2. Convert date-time string to class Date
  3. How to convert Excel date format to proper date in R
  4. How to flatten / merge overlapping time periods
  5. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  6. Add (subtract) months without exceeding the last day of the new month
  7. Convert two-digit years to four-digit years with correct century
  8. Create a Vector of All Days Between Two Dates
  9. Axis labels on two lines with nested x variables (year below months)
  10. Get the difference between dates in terms of weeks, months, quarters, and years
  11. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  12. How to change multiple Date formats in same column?
  13. How to get week numbers from dates?
  14. How to get a vertical geom_vline to an x-axis of class date?
  15. Add a month to a Date [duplicate]
  16. How to subtract/add days from/to a date?
  17. Formatting dates with scale_x_date in ggplot2
  18. Convert a numeric month to a month abbreviation
  19. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  20. Convert four digit year values to class Date
  21. Convert string to date, format: “dd.mm.yyyy”
  22. Convert yyyymmdd string to Date class in R
  23. Efficient and accurate age calculation (in years, months, or weeks) in R given birth date and an arbitrary date
  24. Format date as Year/Quarter
  25. Converting a character string into a date in R
  26. Create end of the month date from a date variable
  27. Convert Factor to Date/Time in R
  28. Adding 15 business days in lubridate
  29. How to convert a date from a character string?
  30. Get date difference in years (floating point)

Leave a Comment