Re: [R] problem converting character to dates

I have imported the data fram Excel and it comes like this: Calendar Year/Month 01.2008 01.2008 01.2008 01.2008 01.2008 02.2008 02.2008 Calendar year / week01.2008 02.2008 03.2008 04.2008 05.2008 05.2008 06.2008 There are repeats in the weeks both belonging to two months. It's the same at

Re: [R] problem converting character to dates

You have to think about if week i in the database means week i-1 in R, perhaps? Uwe Ligges On 13.05.2011 10:47, Assu wrote: Thanks Uwe, it works! I just have a problem at week 53 which gives me an NA. I guess, this week 53 has to do with the data type set at the database design and collectio

Re: [R] problem converting character to dates

Thanks Uwe, it works! I just have a problem at week 53 which gives me an NA. I guess, this week 53 has to do with the data type set at the database design and collection of data. Depends on the week/year kind of counting. -- View this message in context: http://r.789695.n4.nabble.com/problem-co

Re: [R] problem converting character to dates

On 12.05.2011 17:40, Assu wrote: Hi all, I've searched this problem and still I can't understand my results, so here goes: I have some time series I've imported from excel with the dates in text format from excel. Data was imported with RODBC, sqlQuery() function. I have these dates: adates

[R] problem converting character to dates

Hi all, I've searched this problem and still I can't understand my results, so here goes: I have some time series I've imported from excel with the dates in text format from excel. Data was imported with RODBC, sqlQuery() function. I have these dates: >adates [1] "01/2008" "02/2008" "03/2008"