question about date's

x<-as.Date(c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05"))
weekdays(x)
[1] "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃŽÂÃ¥" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃÂÃ¹" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃˆÂÃ•" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃ’ÂÂ»" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÂ¶ÂÃ¾"
months(x)
[1] "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚"

======= 2005-12-12 20:17:38 ÂÃ„ÂÃºÂÃ”ÂÃšÂÃ€ÂÂ´ÂÃÂÃ…ÂÃ–ÂÃÂÃÂÂ´ÂÂµÂÃ€ÂÂ£ÂÂº=======
Thanks!
That solves my problem for year numbers and month numbers
Any idea how to do this for week numbers?

Regards,
Richard

On 12/12/05, ronggui <042045003 at fudan.edu.cn> wrote:
This is one way to do it.
x<-c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05")
x
[1] "2005-07-01" "2005-07-02" "2005-07-03" "2005-07-04" "2005-07-05"
substr(x,1,4)
[1] "2005" "2005" "2005" "2005" "2005"
substr(x,6,7)
[1] "07" "07" "07" "07" "07"
substr(x,9,10)
[1] "01" "02" "03" "04" "05"

======= 2005-12-12 20:06:00 ÂÃ„ÂÃºÂÃ”ÂÃšÂÃ€ÂÂ´ÂÃÂÃ…ÂÃ–ÂÃÂÃÂÂ´ÂÂµÂÃ€ÂÂ£ÂÂº=======

Hi,

Given a frame with calendar date's:

"2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05",etc.

I want to extract the following from these dates:

week number
month number
year number

Any ideas how to accomplish this?

Many thanks.

Regards,
Richard

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

x<-as.Date(c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05"))
weekdays(x)
[1] "??????" "??????" "??????" "??????" "??????"

months(x)
[1] "????" "????" "????" "????" "????"
He asked for week numbers.  That's nothing like as easy, as it is not
well-defined.  But
strftime(as.POSIXlt(x), "%U")
[1] "26" "26" "27" "27" "27"

is one possibility ("%W" is another).  This approach will do the other
requests just as easily.
======= 2005-12-12 20:17:38 ????????????????=======

Thanks!
That solves my problem for year numbers and month numbers
Any idea how to do this for week numbers?

Regards,
Richard

On 12/12/05, ronggui <042045003 at fudan.edu.cn> wrote:
This is one way to do it.
x<-c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05")
x
[1] "2005-07-01" "2005-07-02" "2005-07-03" "2005-07-04" "2005-07-05"
substr(x,1,4)
[1] "2005" "2005" "2005" "2005" "2005"
substr(x,6,7)
[1] "07" "07" "07" "07" "07"
substr(x,9,10)
[1] "01" "02" "03" "04" "05"

======= 2005-12-12 20:06:00 ????????????????=======

Hi,

Given a frame with calendar date's:

"2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05",etc.

I want to extract the following from these dates:

week number
month number
year number

Any ideas how to accomplish this?

Many thanks.

Regards,
Richard

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595
this is what I was looking for!
many many thanks!

regards,
richard
On Mon, 12 Dec 2005, ronggui wrote:

x<-as.Date(c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05"))
weekdays(x)
[1] "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃŽÂÃ¥" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃÂÃ¹" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃˆÂÃ•" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÃ’ÂÂ»" "ÂÃÂÃ‡ÂÃ†ÂÃšÂÂ¶ÂÃ¾"

months(x)
[1] "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚" "ÂÃ†ÂÃŸÂÃ”ÂÃ‚"

He asked for week numbers.  That's nothing like as easy, as it is not
well-defined.  But

strftime(as.POSIXlt(x), "%U")
[1] "26" "26" "27" "27" "27"

is one possibility ("%W" is another).  This approach will do the other
requests just as easily.

======= 2005-12-12 20:17:38 ÂÃ„ÂÃºÂÃ”ÂÃšÂÃ€ÂÂ´ÂÃÂÃ…ÂÃ–ÂÃÂÃÂÂ´ÂÂµÂÃ€ÂÂ£ÂÂº=======

Thanks!
That solves my problem for year numbers and month numbers
Any idea how to do this for week numbers?

Regards,
Richard

On 12/12/05, ronggui <042045003 at fudan.edu.cn> wrote:
This is one way to do it.
x<-c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05")
x
[1] "2005-07-01" "2005-07-02" "2005-07-03" "2005-07-04" "2005-07-05"
substr(x,1,4)
[1] "2005" "2005" "2005" "2005" "2005"
substr(x,6,7)
[1] "07" "07" "07" "07" "07"
substr(x,9,10)
[1] "01" "02" "03" "04" "05"

======= 2005-12-12 20:06:00 ÂÃ„ÂÃºÂÃ”ÂÃšÂÃ€ÂÂ´ÂÃÂÃ…ÂÃ–ÂÃÂÃÂÂ´ÂÂµÂÃ€ÂÂ£ÂÂº=======

Hi,

Given a frame with calendar date's:

"2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05",etc.

I want to extract the following from these dates:

week number
month number
year number

Any ideas how to accomplish this?

Many thanks.

Regards,
Richard

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

--
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

Prof Brian Ripley <ripley at stats.ox.ac.uk> writes:
On Mon, 12 Dec 2005, ronggui wrote:

x<-as.Date(c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05"))
weekdays(x)
[1] "????????????" "????????????" "????????????" "????????????" "????????????"

months(x)
[1] "????????" "????????" "????????" "????????" "????????"

He asked for week numbers.  That's nothing like as easy, as it is not
well-defined.  But

strftime(as.POSIXlt(x), "%U")
[1] "26" "26" "27" "27" "27"

is one possibility ("%W" is another).  This approach will do the other
requests just as easily.
%W seems to be what is known as "ISO dates" (week starts on Monday),
except that
 strftime(as.POSIXlt(as.Date("2005-01-01")), "%U")
[1] "00"

should be week 53, 2004 according to my printed calendar, and emacs
calendar-mode too.
======= 2005-12-12 20:17:38 ????????????????????????????????=======

Thanks!
That solves my problem for year numbers and month numbers
Any idea how to do this for week numbers?

Regards,
Richard

On 12/12/05, ronggui <042045003 at fudan.edu.cn> wrote:
This is one way to do it.
x<-c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05")
x
[1] "2005-07-01" "2005-07-02" "2005-07-03" "2005-07-04" "2005-07-05"
substr(x,1,4)
[1] "2005" "2005" "2005" "2005" "2005"
substr(x,6,7)
[1] "07" "07" "07" "07" "07"
substr(x,9,10)
[1] "01" "02" "03" "04" "05"

======= 2005-12-12 20:06:00 ????????????????????????????????=======

Hi,

Given a frame with calendar date's:

"2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05",etc.

I want to extract the following from these dates:

week number
month number
year number

Any ideas how to accomplish this?

Many thanks.

Regards,
Richard

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

= = = = = = = = = = = = = = = = = = = =

2005-12-12

------
Deparment of Sociology
Fudan University

My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

O__  ---- Peter Dalgaard             ??ster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark          Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)                  FAX: (+45) 35327907

Prof Brian Ripley <ripley at stats.ox.ac.uk> writes:

On Mon, 12 Dec 2005, ronggui wrote:

x<-as.Date(c("2005-07-01", "2005-07-02","2005-07-03","2005-07-04","2005-07-05"))
weekdays(x)
[1] "??????" "??????" "??????" "??????" "??????"

months(x)
[1] "????" "????" "????" "????" "????"

He asked for week numbers.  That's nothing like as easy, as it is not
well-defined.  But

strftime(as.POSIXlt(x), "%U")
[1] "26" "26" "27" "27" "27"

is one possibility ("%W" is another).  This approach will do the other
requests just as easily.
%W seems to be what is known as "ISO dates" (week starts on Monday),
except that

 strftime(as.POSIXlt(as.Date("2005-01-01")), "%U")
[1] "00"

should be week 53, 2004 according to my printed calendar, and emacs
calendar-mode too.
I _did_ say
That's nothing like as easy, as it is not well-defined.
The POSIX definition is

%U
     Replaced by the week number of the year as a decimal number [00,53].
     The first Sunday of January is the first day of week 1; days in the
     new year before this are in week 0.

%W
     Replaced by the week number of the year as a decimal number [00,53].
     The first Monday of January is the first day of week 1; days in the
     new year before this are in week 0.

so it is doing what it is documented to do.  I'd take POSIX as more 
definitive than Emacs ....
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595
Prof Brian Ripley <ripley at stats.ox.ac.uk> writes:
%W seems to be what is known as "ISO dates" (week starts on Monday),
except that

 strftime(as.POSIXlt(as.Date("2005-01-01")), "%U")
[1] "00"

should be week 53, 2004 according to my printed calendar, and emacs
calendar-mode too.
I _did_ say

That's nothing like as easy, as it is not well-defined.
The POSIX definition is

%U
     Replaced by the week number of the year as a decimal number [00,53].
     The first Sunday of January is the first day of week 1; days in the
     new year before this are in week 0.

%W
     Replaced by the week number of the year as a decimal number [00,53].
     The first Monday of January is the first day of week 1; days in the
     new year before this are in week 0.

so it is doing what it is documented to do.  I'd take POSIX as more
definitive than Emacs ....
But not more definitive than the ISO standard, I hope. There are
probably more that 1e8 calendars printed each year according that one. 

The two routines are just not doing the same thing. Calendar-mode goes
by the ISO standard, strftime by POSIX definitions. Of course it all
depends on what the user actually wanted.
O__  ---- Peter Dalgaard             ??ster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark          Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)                  FAX: (+45) 35327907