[Arrow] Filtering an arrow table between a range of dates

General
, ,
2

Hi @TPDeRamus,

I'm not familiar with the %within% function, is it part of the arrow package?

The following uses base::as.Date() and dplyr::between(), which seems to do a similar thing?

data |> 
  filter(between(ADate, as.Date('2000-01-01'), as.Date('2010-01-01')))

alternatively, specifying upper and lower date limits like this:

data |> 
  filter(
    ADate >= as.Date('2000-01-01'), 
    ADate <= as.Date('2010-01-01')
  )
1 Like