Try this:
> x
startdate enddate
1 27SEP2005 01JAN2006> x$start <- as.Date(x$startdate, format="%d%b%Y")
> x$end <- as.Date(x$enddate, format="%d%b%Y")
> x
startdate enddate start end
1 27SEP2005 01JAN2006 2005-09-27 2006-01-01> x$duration <- x$end - x$start
> x
startdate enddate start end duration
1 27SEP2005 01JAN2006 2005-09-27 2006-01-01 96 days>
On Sun, Aug 29, 2010 at 8:20 AM, Andr? de Boer <rnieuws at gmail.com>
wrote:> Hi,
>
> I have a data.frame with factors in columns like
>
> startdate ? ? ?enddate
> 27SEP2005 01JAN2006
>
> How can I calculate the duration between those two dates and move this in a
> extra column in the data.frame.
>
> Thanks,
> Andr?
>
> ? ? ? ?[[alternative HTML version deleted]]
>
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?