[R] Creating a Date Field

[Jeff Newmiller]

You are not comparing your character date data with the format string. Specifically there are no spaces in your data but there are in your format string. Any characters in the format string that are not part of % date component specifications must be found in your data.

On September 24, 2019 4:54:00 PM PDT, Phillip Heinrich <herd_dog using cox.net> wrote:
>The date is imbedded in the GameID character field so I created a date
>vector with the following code:
>
>ari18.test3$date <- substring(ari18.test3$GameID,4,11)  And then
>created a new dataframe with just the Game ID and date vectors.  The
>date field is a character as shown by the str() command. str(test)
>'data.frame':	3 obs. of  2 variables:
> $ GameID: Factor w/ 3 levels "ARI201803290",..: 1 2 3
>$ date  : chr  "20180329" "20180330" "20180331"           GameID    
>date
>1   ARI201803290 20180329
>81  ARI201803300 20180330
>165 ARI201803310 20180331
>> My notes from about a week ago say that the following code will turn
>“date” into a date field: test$date <- as.Date(test$date,format="%Y %M
>%D")  date becomes a date field but the data disappears into NA  
>str(test)
>'data.frame':	3 obs. of  2 variables:
> $ GameID: Factor w/ 3 levels "ARI201803290",..: 1 2 3
> $ date  : Date, format: NA NA NA  What am I missing here?
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.

-- 
Sent from my phone. Please excuse my brevity.