Re: [R] Subset based on a date range

2012-05-19 Thread Uwe Ligges
On 19.05.2012 15:34, Allen wrote: Hello, Can someone help me on how to make a subset of my dataframe using two dates. This is what I have tried, but no data is being excluded in the new frame. six_months<-subset(Two_years, vdate>2011-01-01|vdate<2011-07-01) Convert the *string* "2011-01-01

[R] Subset based on a date range

2012-05-19 Thread Allen
Hello, Can someone help me on how to make a subset of my dataframe using two dates. This is what I have tried, but no data is being excluded in the new frame. six_months<-subset(Two_years, vdate>2011-01-01|vdate<2011-07-01) or all data is excluded six_months<-subset(Two_years, vdate>2011-01-01

Re: [R] Subset based on a date range

2012-05-19 Thread Rui Barradas
Hello, You are not using dates. > 2011-01-01 [1] 2009 > 2011-07-01 [1] 2003 > as.Date(2011-07-01) Error in as.Date.numeric(2011 - 7 - 1) : 'origin' must be supplied > as.Date("2011-07-01") [1] "2011-07-01" The error is because as.Date is seeing 2003 as a number, the number of days since an uns