Re: [R] sqldf Date problem

2012-11-04 Thread Andreas Recktenwald
Zitat von jim holtman : Most likely your "Date" is either a character or a factor (you need to provide an 'str' of the dataframe). You are therefore most likely doing a character compare and that is the reason for your problem. You need to convert to a character string of the format -MM-DD

Re: [R] sqldf Date problem

2012-11-03 Thread jim holtman
Most likely your "Date" is either a character or a factor (you need to provide an 'str' of the dataframe). You are therefore most likely doing a character compare and that is the reason for your problem. You need to convert to a character string of the format -MM-DD to do the correct character

[R] sqldf Date problem

2012-11-03 Thread Andreas Recktenwald
Dear R-help readers, i've created a database for quotes data (for 4 years; 2007 -- 2010) with the sqldf package. This database contains a column "Date" in the format mm/dd/. The table in the database is called "main.data" and the database itself "Honda". I tried to get the Data just f

[R] sqldf Date problem

2012-11-03 Thread Andreas Recktenwald
Dear R-help readers, i've created a database for quotes data (for 4 years; 2007 -- 2010) with the sqldf package. This database contains a column "Date" in the format mm/dd/. The table in the database is called "main.data" and the database itself "Honda". I tried to get the Data just