search for: newday

Dear friends, I need to fill in (duplicate the whole record) the missing days with the same record values as long as AE is the same value (i.e. "1"), once AE value changes, the process of duplication should proceed with the new AE value till it changes again. e.g. I need to fill in records: day 18-day 44, all the records are carried with the new AE value of "0". At the

Hello, I gather variants of this question have been asked previously. I have done some reading but only became more confused, as I suspect what I am trying to do is more basic than other applications. The following code readily calculates the difference in days between two dates: newdays <- ISOdate(2005, 5,12) - ISOdate(2006, 12, 22) However, I wanted to be able to deduct the dates in one variable from the dates in another variable, resulting in a new variable - e.g the difference in days between the two dates. Below is a sample of my data. My questions: 1. I tried changin...