s-news
[Top] [All Lists]

Problem with hour 24 vs. hour 0 in timeDate

To: s-news@lists.biostat.wustl.edu
Subject: Problem with hour 24 vs. hour 0 in timeDate
From: Sarah Henderson <sarah.henderson@ubc.ca>
Date: Thu, 14 Jul 2005 08:38:50 -0800

Hello to all --

This may be a simple problem but I (as a relatively novice user) cannot make headway without some help.

I have received several data sets with a character date/time stamp in the format YYYYMMDDHH where 00:00 to 01:00 on June 1st 2003 would be represented as 2003053124 instead of 2003060100. I am trying format this string as follows for some time-series plotting:


timeDate(date.time, in.format="%4Y%2m%2d%2H", format="%02d %b %Y %02H:%02M")


This works as expected for the 01 through 23 hour values, but I receive NA for all the 24 hour values which, of course, is not very helpful. I also get the message "The time output format specified: 'HH' is invalid. Setting value to [NONE]." If anyone can suggest an amendment or a work-around, I would greatly appreciate it. I am working on S-PLUS 6.2 (student edition) in a Windows environment.

Thanks for your attention.

Sarah

______________________________________________

Sarah Henderson
Department of Health Care & Epidemiology
University of British Columbia
Phone: 604.822.1274
Fax: 604.822.9588

Michael Smith Foundation for Health Research Trainee
Canadian Institutes of Health Research Trainee

<Prev in Thread] Current Thread [Next in Thread>