[R-SIG-Finance] About timeDate Problem

[Chirag Anand]

On Sunday 06 Jun 2010 6:54:12 pm Guy Green wrote:
> I may be missing something on this, but it seems timeDate is quite
>  difficult to work with.  For example, the following code shows some dates
>  working, and others not, but it is hard to see what the difference is
>  except that timeDate has difficulty dealing with single digit dates:
> 
> timeDate("6/7/2010", format = "%m/%d/%Y")  #works fine
> timeDate("5/28/2010", format = "%m/%d/%Y")  #works fine
> timeDate(c("6/7/2010", "5/28/2010"), format = "%m/%d/%Y")  #doesn't work. 
>  I have no idea why the dates work on their own (above), but not together.
>  timeDate(c("06/07/2010", "05/28/2010"), format = "%m/%d/%Y")  #works - so
>  the single/double issue seems to be the cause of the problem
> timeDate(c("06-07-2010", "05-28-2010"), format = "%m-%d-%Y")  #works fine
> 
> Could you just use as.Date?  Does this get you what you wanted?
> 
> date <- read.csv("D:/date.csv",header=T,sep=",")
> date2 = as.Date(date$Date, format = "%m/%d/%Y")
> date2
 
If you still wants to use timeDate class, you can convert from Date class:
  dateNew <- as.timeDate(date2)
  dateNew
 
Probably, it has difficulty dealing with string of characters but from vector of "Date", 
it works fine.
 
-- 
Regards
Chirag Anand