... ISO 8601 requires two digits for the day of the month: R/0000-07-01/P1Y Michael Deckers....
2211
piebaldconsult
May 14, 2011 2:38 pm
A recurring time interval that starts on 0000-07-1 with duration of one year: R/0000-07-1/P1Y...
2210
Nguyen, Ivy A
ali0917
May 13, 2011 9:46 pm
Wouldn't one stick a hyphen where the year is if no year is being used or is known (eg R/P1Y/--07-01)? ... From: "marcus.aurelia" <marcus.aurelia@...> ...
2209
marcus.aurelia
May 13, 2011 9:30 pm
Hi! I'm new in this group and I haven't read all the former posts... I hope the answer to my question isn't already in one of them! How would you represent...
2208
Paul Myers
prmyers@...
Aug 15, 2010 11:27 am
Thanks for the info, Tex. I already know about the "available" Excel formats that can be accessed via the "Format()" statement in VBA for Excel as well as the ...
2207
Will Scott
bbflatt
Aug 15, 2010 11:24 am
I think Paul's question was how to get Excel to display dates in the format YYYY-DDD, e.g. 2010-198 for today's date. I think this formula will give you what...
2206
Tex Texin
textexin
Jul 18, 2010 10:20 pm
John, thanks. Paul, sorry I read too fast. Given a date as a serial number, the =YEAR(datenumber) function gives the year and you can use that to create Jan 1...
2205
John Bogie
jaberwok10
Jul 18, 2010 10:51 am
That's not what the OP asked about; he wants year and day number. Anyway, the yyyy-mm-dd format is already available in Excel (2007, at least, and when Windows...
2204
Tex Texin
textexin
Jul 17, 2010 9:10 pm
If you go into number formats and choose custom, you can enter yyyy-mm-dd or yyyymmdd. If you need a macro to accomplish that, turn on macro recording and...
2203
prmyers1
Jul 17, 2010 8:06 pm
Has anyone come across an Excel macro (ideally compatible with all versions from Excel 2000 onwards) for formatting cells for the ISO8601 "Day in Year" format...
2202
piebaldconsult
Nov 6, 2009 4:26 pm
... I agree with that interpretation. On the other hand, I expect that you and your partners in interchange could mutually agree that it means what you want;...
2201
johnmsteele
Nov 6, 2009 1:45 pm
I'm not sure you can. In 2004 version, section 2.1.17 is clear that recurring time interval is defined as consecutive time periods. What you want requires a...
2200
john.hockaday@...
jhock96
Nov 6, 2009 12:36 pm
Hi, How does one show the first quarter (January to March) of every year using ISO 8601. I know that recurring is represented by "R" and that a period for the...
2199
jhock96
Nov 6, 2009 12:36 pm
Hi, How do I represent the first three months of every year in ISO 8601. I know one can represent a period by "P3M" and one can represent a recurring period...
2198
Deckers, Michael
michael.deckers
Jun 4, 2009 6:50 pm
... That's fine if your application imposes such restrictions, but it is not what ISO 8601 requires. ISO 8601 fixes some notations but it does not constrain...
2197
piebaldconsult
Jun 1, 2009 2:57 am
... Personally, I think that would be fairly silly....
2196
Tex Texin
textexin
May 31, 2009 1:13 am
Reading through that thread, after the first few lines, I am not sure it is what I would call healthy debate. But it is nice that yyyymmdd is becoming more...
2195
g1smd_amsat_org
May 30, 2009 10:50 pm
[2009-May-30] Ten years on, and some communities are still having healthy debate... ...
2194
G Ashton
pqrc96
May 29, 2009 5:33 pm
When I mentioned in an earlier post that I would reject certain date-times in the ISO 8601 format, I meant that I would halt processing or flag them for...
2193
John Steele
johnmsteele
May 29, 2009 12:56 pm
Tex,  I agree with the dilemma you pose. In reality, that means date alone often does not suffice and you must consider time of day as well.  However, in...
2192
Tex Texin
textexin
May 29, 2009 11:54 am
John Good comments. I am surprised by your comment on dates. Dates definitely do have time zones. Since time zones span 25 hours, without mention of the zone, ...
2191
johnmsteele
May 29, 2009 11:39 am
I agree with Tex's remarks. But I would add the following three points: *Dates don't have time zones. Only times or "date and time" representations have time...
2190
Tex Texin
textexin
May 29, 2009 9:46 am
Hi, You are welcome to do whatever you want of course, but I don’t think this is what was suggested or recommended and I don’t think you should in any way ...
2189
pqrc96
May 29, 2009 9:21 am
I started this thread. After seeing the responses, I don't really see anything that would change my ideas, but knowing that my thoughts have been reviewed by...
2188
Tex Texin
textexin
May 27, 2009 4:26 am
Your first mail may have bounced, it looks like the from address was messed up. However, your subsequent mails seemd to be forwards of the bounced mail and ...
2183
bam@...
websitedevel...
May 27, 2009 3:19 am
The original message was received at 2009-05-26 23:15:29 -0400 from postoffice.local [10.0.0.1] ... <bam@... Below is a copy of another message that...
2182
nguyenivy@...
ali0917
May 26, 2009 11:35 pm
I was thinking of historical examples like the offset The Netherlands used sometime in the last 100 years that had an offset precise to the centisecond....
2181
piebaldconsult
May 26, 2009 2:09 pm
... Yes, but seconds generally aren't important in day-to-day events anyway. If you're going to try to calculate an offset to great precision you may need to...
2180
piebaldconsult
May 26, 2009 2:03 pm
... True, so we may never know the offset, but that doesn't interfere with using ISO 8601. You can simply indicate "local time" by not specifying the offset....
2179
nguyenivy@...
ali0917
May 25, 2009 8:53 am
Right. Doesn't the standard call for a proleptic Gregorian calender for dates before 1582 & after the present (and that more digits/negative dates are allowed...
