Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

add_period_to_date/add_months returns NA for some dates/periods #633

Closed
mwmclean opened this issue Feb 5, 2018 · 1 comment
Closed

add_period_to_date/add_months returns NA for some dates/periods #633

mwmclean opened this issue Feb 5, 2018 · 1 comment
Labels
bug an unexpected problem or unintended behavior

Comments

@mwmclean
Copy link

mwmclean commented Feb 5, 2018

library(lubridate)
start <- c("2016-04-29 12:00:00 GMT", "2013-10-31 12:00:00 GMT", "2012-05-31 12:00:00 GMT", "2010-06-29 12:00:00 GMT",
           "2014-12-31 12:00:00 GMT", "2015-08-31 12:00:00 GMT", "2013-03-29 12:00:00 GMT", "2014-07-31 12:00:00 GMT")
end <- c("2017-03-25", "2014-03-16", "2012-12-15", "2011-03-25", "2015-10-16" ,"2016-03-16", "2014-03-28" ,"2015-07-22")
mt <- as.POSIXlt(start)
int <- interval(start, end)
id <- int %/% months(1)

int %% months(1)
## [1] NA--NA NA--NA NA--NA NA--NA NA--NA NA--NA NA--NA NA--NA
mt + months(id)
## [1] NA NA NA NA NA NA NA NA
lubridate:::add_months(mt, id)
## [1] NA NA NA NA NA NA NA NA
@mwmclean mwmclean closed this as completed Feb 6, 2018
@mwmclean mwmclean changed the title add_period_to_date/add_months fails for some dates/periods add_period_to_date/add_months returns NA for some dates/periods Feb 7, 2018
@mwmclean mwmclean reopened this Feb 7, 2018
@vspinu vspinu added the bug an unexpected problem or unintended behavior label Feb 22, 2018
@vspinu vspinu closed this as completed in fa5520f Apr 10, 2018
@vspinu
Copy link
Member

vspinu commented Apr 10, 2018

I am fixing %% issue as I think it would make more sense to use m+ arithmetic there but others behave as expected. See the docs for %m+%.

With the github version you should see:

> int %% months(1)
[1] 2017-02-28 12:00:00 CET--2017-03-25 CET  
[2] 2014-02-28 12:00:00 CET--2014-03-16 CET  
[3] 2012-11-30 12:00:00 CET--2012-12-15 CET  
[4] 2011-02-28 12:00:00 CET--2011-03-25 CET  
[5] 2015-09-30 12:00:00 CEST--2015-10-16 CEST
[6] 2016-02-29 12:00:00 CET--2016-03-16 CET  
[7] 2014-02-28 12:00:00 CET--2014-03-28 CET  
[8] 2015-06-30 12:00:00 CEST--2015-07-22 CEST
> mt + months(id)
[1] NA NA NA NA NA NA NA NA
> mt %m+% months(id)
[1] "2017-02-28 12:00:00 UTC" "2014-02-28 12:00:00 UTC"
[3] "2012-11-30 12:00:00 UTC" "2011-02-28 12:00:00 UTC"
[5] "2015-09-30 12:00:00 UTC" "2016-02-29 12:00:00 UTC"
[7] "2014-02-28 12:00:00 UTC" "2015-06-30 12:00:00 UTC"
> add_with_rollback(mt, months(id))
[1] "2017-02-28 12:00:00 UTC" "2014-02-28 12:00:00 UTC"
[3] "2012-11-30 12:00:00 UTC" "2011-02-28 12:00:00 UTC"
[5] "2015-09-30 12:00:00 UTC" "2016-02-29 12:00:00 UTC"
[7] "2014-02-28 12:00:00 UTC" "2015-06-30 12:00:00 UTC"
> add_with_rollback(mt, months(id), T, F)
[1] "2017-03-01 UTC" "2014-03-01 UTC" "2012-12-01 UTC" "2011-03-01 UTC"
[5] "2015-10-01 UTC" "2016-03-01 UTC" "2014-03-01 UTC" "2015-07-01 UTC"

netbsd-srcmastr pushed a commit to NetBSD/pkgsrc that referenced this issue May 30, 2021
Version 1.7.10
==============

### NEW FEATURES

* `fast_strptime()` and `parse_date_time2()` now accept multiple formats and apply them in turn

### BUG FIXES

* [#926](tidyverse/lubridate#926) Fix incorrect division of intervals by months involving leap years
* Fix incorrect skipping of digits during parsing of the `%z` format

Version 1.7.9.2
===============

### NEW FEATURES

* [#914](tidyverse/lubridate#914) New `rollforward()` function
* [#928](tidyverse/lubridate#928) On startup lubridate now resets TZDIR to a proper directory when it is set to non-dir values like "internal" or "macOS" (a change introduced in R4.0.2)
* [#630](tidyverse/lubridate#630) New parsing functions `ym()` and `my()`

### BUG FIXES

* [#930](tidyverse/lubridate#930) `as.period()` on intervals now returns valid Periods with double fields (not integers)



Version 1.7.9
=============

### NEW FEATURES

* [#871](tidyverse/lubridate#893) Add `vctrs` support


### BUG FIXES

* [#890](tidyverse/lubridate#890) Correctly compute year in `quarter(..., with_year = TRUE)`
* [#893](tidyverse/lubridate#893) Fix incorrect parsing of abbreviated months in locales with trailing dot (regression in v1.7.8)
* [#886](tidyverse/lubridate#886) Fix `with_tz()` for POSIXlt objects
* [#887](tidyverse/lubridate#887) Error on invalid numeric input to `month()`
* [#889](tidyverse/lubridate#889) Export new dmonth function

Version 1.7.8
=============

### NEW FEATURES

* (breaking) Year and month durations now assume 365.25 days in a year consistently in conversion and constructors. Particularly `dyears(1) == years(1)` is now `TRUE`.
* Format and print methods for 0-length objects are more consistent.
* New duration constructor `dmonths()` to complement other duration constructors.
*
* `duration()` constructor now accepts `months` and `years` arguments.
* [#629](tidyverse/lubridate#629) Added `format_ISO8601()` methods.
* [#672](tidyverse/lubridate#672) Eliminate all partial argument matches
* [#674](tidyverse/lubridate#674) `as_date()` now ignores the `tz` argument
* [#675](tidyverse/lubridate#675) `force_tz()`, `with_tz()`, `tz<-` convert dates to date-times
* [#681](tidyverse/lubridate#681) New constants `NA_Date_` and `NA_POSIXct_` which parallel built-in primitive constants.
* [#681](tidyverse/lubridate#681) New constructors `Date()` and `POSIXct()` which parallel built-in primitive constructors.
* [#695](tidyverse/lubridate#695) Durations can now be compared with numeric vectors.
* [#707](tidyverse/lubridate#707) Constructors return 0-length inputs when called with no arguments
* [#713](tidyverse/lubridate#713) (breaking) `as_datetime()` always returns a `POSIXct()`
* [#717](tidyverse/lubridate#717) Common generics are now defined in `generics` dependency package.
* [#719](tidyverse/lubridate#719) Negative Durations are now displayed with leading `-`.
* [#829](tidyverse/lubridate#829) `%within%` throws more meaningful messages when applied on unsupported classes
* [#831](tidyverse/lubridate#831) Changing hour, minute or second of Date object now yields POSIXct.
* [#869](tidyverse/lubridate#869) Propagate NAs to all internal components of a Period object

### BUG FIXES

* [#682](tidyverse/lubridate#682) Fix quarter extraction with small `fiscal_start`s.
* [#703](tidyverse/lubridate#703) `leap_year()` works with objects supported by `year()`.
* [#778](tidyverse/lubridate#778) `duration()/period()/make_difftime()` work with repeated units
* `c.Period` concatenation doesn't fail with empty components.
* Honor `exact = TRUE` argument in `parse_date_time2`, which was so far ignored.

Version 1.7.4
=============

### NEW FEATURES

* [#658](tidyverse/lubridate#658) `%within%` now accepts a list of intervals, in which case an instant is checked if it occurs within any of the supplied intervals.

### CHANGES

* [#661](tidyverse/lubridate#661) Throw error on invalid multi-unit rounding.
* [#633](tidyverse/lubridate#633) `%%` on intervals relies on `%m+` arithmetic and doesn't produce NAs when intermediate computations result in non-existent dates.
* `tz()` always returns "UTC" when `tzone` attribute cannot be inferred.

### BUG FIXES

* [#664](tidyverse/lubridate#664) Fix lookup of period functions in `as.period`
* [#649](tidyverse/lubridate#664) Fix system timezone memoization

Version 1.7.3
=============

### BUG FIXES

* [#643](tidyverse/lubridate#643), [#640](tidyverse/lubridate#640), [#645](tidyverse/lubridate#645) Fix faulty caching of system timezone.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug an unexpected problem or unintended behavior
Projects
None yet
Development

No branches or pull requests

2 participants