[R] Undesired result

Val v@|kremk @end|ng |rom gm@||@com
Wed Feb 17 15:50:52 CET 2021


HI All,

I am reading a data file which has different date formats. I wanted to
standardize to one format and used  a library anytime but got
undesired results as shown below. It gave me year 2093 instead of 1993


library(anytime)
DFX<-read.table(text="name ddate
  A  19-10-02
  D  11/19/2006
  F  9/9/2011
  G1  12/29/2010
  AA   10/18/93 ",header=TRUE)
    getFormats()
    addFormats(c("%d-%m-%y"))
    addFormats(c("%m-%d-%y"))
    addFormats(c("%Y/%d/%m"))
    addFormats(c("%m/%d/%y"))

DFX$anew=anydate(DFX$ddate)

Output
 name      ddate       anew
1    A   19-10-02 2002-10-19
2    D 11/19/2006 2020-11-19
3    F   9/9/2011 2011-09-09
4   G1 12/29/2010 2020-12-29
5   AA   10/18/93 2093-10-18

The problem is in the last row. It should be  1993-10-18 instead of 2093-10-18

How do I correct this?
Thank you.



More information about the R-help mailing list