Ravi S. Shankar
2010-Apr-05 16:44 UTC
[R] subtract a specified number of days from current date
Hi R, I have a column with dates. I need to create a vector say from (current date-90 days: current date) For example I need to subtract 90 days from say Sys.Date()-92 If Sys.Date()-92 == "Sunday", Sys.Date()-92+1 if Sys.Date()-92 == "Saturday", Sys.Date()-92+2 i.e if subtracting gives me a weekend I need the next work day. I used the below. ifelse(weekdays(seq(seq(tf[[i]][j,1],by="-1 day",length.out=90)[90])=="Saturday",match(seq(tf[[i]][j,1],by="-1 day",length.out=90)[90]+2,tf[[i]][,1]),ifelse(weekdays(seq(tf[[i]][j,1], by="-1 day",length.out=90)[90])=="Sunday",match(seq(tf[[i]][j,1],by="-1 day",length.out=90)[90]+1,tf[[i]][,1]),match(seq(tf[[i]][j, 1],by="-1 day",length.out=90)[90],tf[[i]][,1]))) I would be grateful If anybody can help me with a more elegant/efficient approach. Thank you in advance for your time! Ravi This e-mail may contain confidential and/or privileged i...{{dropped:13}}