On 2017-08-22 2:04 PM, Patrick Casimir wrote: > > This is large data set Spencer. What about when the dates change as below: >
����� Have you tried what I suggested?� What were the results? Spencer > > COL1 COL2 > Jan-14 1-Aug-16 > Feb-14 1-Aug-16 > Mar-14 1-Aug-16 > Apr-14 1-Aug-16 > May-14 1-Aug-16 > Jun-14 1-Aug-16 > Jul-14 1-Aug-16 > Aug-14 1-Aug-16 > Sep-14 1-Aug-16 > Oct-14 1-Aug-16 > Nov-14 1-Aug-16 > Dec-14 1-Aug-16 > Jan-15 1-Aug-16 > Feb-15 1-Aug-16 > Mar-15 1-Aug-16 > Apr-15 1-Aug-16 > May-15 1-Aug-16 > Jun-15 1-Aug-16 > Jul-15 1-Aug-16 > Aug-15 1-Aug-16 > Sep-15 1-Aug-16 > Oct-15 1-Aug-16 > Nov-15 1-Aug-16 > Dec-15 1-Aug-16 > Jan-16 1-Aug-16 > Feb-16 1-Aug-16 > Mar-16 1-Aug-16 > Apr-16 1-Aug-16 > May-16 1-Aug-16 > Jun-16 1-Aug-16 > Jul-16 1-Aug-16 > Aug-16 1-Aug-16 > Sep-16 1-Aug-16 > Oct-16 1-Aug-16 > > > > > > > > ------------------------------------------------------------------------ > *From:* R-help <r-help-boun...@r-project.org> on behalf of Spencer > Graves <spencer.gra...@effectivedefense.org> > *Sent:* Tuesday, August 22, 2017 2:49 PM > *To:* r-help@r-project.org > *Subject:* Re: [R] Convert Factor to Date > > > On 2017-08-22 1:30 PM, Patrick Casimir wrote: > > Dear R Fellows, > > > > > > I Have a dataset( data1) with 2 columns of date showing a class of > factor. How to convert them to date? Then compare them, keep the > greater date only in a new column. Using as.Date to change the class > to Date but the data becomes NA. > > > ������ When I specified a format with the second date, I got the desired > behavior: > > > �> as.Date(factor('1-Nov-16'), '%d-%b-%y') > [1] "2016-11-01" > �> as.Date('Nov-16', '%b-%y') > [1] NA > �> as.Date(factor('Nov-16'), '%b-%y') > [1] NA > �> as.Date('Nov-16', '%b-%y') > [1] NA > > > ������ To convert the first column, I pasted "1-" in front: > > > as.Date(paste0('1-', factor('Nov-16')), '%d-%b-%y') > > > ������ Hope this helps.� Spencer > > > Much Thanks > > > > > > COL1��� COL2 > > Apr-16� 1-Nov-16 > > May-16� 1-Nov-16 > > Jun-16� 1-Nov-16 > > Jul-16� 1-Nov-16 > > Aug-16� 1-Nov-16 > > Sep-16� 1-Nov-16 > > Oct-16� 1-Nov-16 > > Nov-16� 1-Nov-16 > > Dec-16� 1-Nov-16 > > Jan-17� 1-Nov-16 > > Feb-17� 1-Nov-16 > > Mar-17� 1-Nov-16 > > Apr-17� 1-Nov-16 > > May-17� 1-Nov-16 > > Jun-17� 1-Nov-16 > > Jul-17� 1-Nov-16 > > Aug-17� 1-Nov-16 > > Sep-17� 1-Nov-16 > > > > > >������� [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > > https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstat.ethz.ch%2Fmailman%2Flistinfo%2Fr-help&data=02%7C01%7Cpatrcasi%40nova.edu%7C6abf3517ab5f407427d308d4e98e9efd%7C2c2b2d312e3e4df1b571fb37c042ff1b%7C0%7C0%7C636390246143633480&sdata=jwTeb%2BvH0bbkXdckgzE6PJZ3gDl9d1%2F3t9K%2BxDtjyls%3D&reserved=0 > > PLEASE do read the posting guide > https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.R-project.org%2Fposting-guide.html&data=02%7C01%7Cpatrcasi%40nova.edu%7C6abf3517ab5f407427d308d4e98e9efd%7C2c2b2d312e3e4df1b571fb37c042ff1b%7C0%7C0%7C636390246143633480&sdata=GUAR582xxtA88KLkQC1oPnvyNecfUyXjV9MrIziJicU%3D&reserved=0 > > and provide commented, minimal, self-contained, reproducible code. > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstat.ethz.ch%2Fmailman%2Flistinfo%2Fr-help&data=02%7C01%7Cpatrcasi%40nova.edu%7C6abf3517ab5f407427d308d4e98e9efd%7C2c2b2d312e3e4df1b571fb37c042ff1b%7C0%7C0%7C636390246143633480&sdata=jwTeb%2BvH0bbkXdckgzE6PJZ3gDl9d1%2F3t9K%2BxDtjyls%3D&reserved=0 > PLEASE do read the posting guide > https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.R-project.org%2Fposting-guide.html&data=02%7C01%7Cpatrcasi%40nova.edu%7C6abf3517ab5f407427d308d4e98e9efd%7C2c2b2d312e3e4df1b571fb37c042ff1b%7C0%7C0%7C636390246143633480&sdata=GUAR582xxtA88KLkQC1oPnvyNecfUyXjV9MrIziJicU%3D&reserved=0 > and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]]
______________________________________________ R-help@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.