Goto Message #
Re: Recurring date ... ISO 8601 requires two digits for the day of the month: R/0000-07-01/P1Y Michael Deckers.
May 15, 2011#2212
Re: Recurring date A recurring time interval that starts on 0000-07-1 with duration of one year: R/0000-07-1/P1Y
May 14, 2011#2211
Re: Recurring date 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"
Nguyen, Ivy A
May 13, 2011#2210
Fetching Sponsored Content...
Recurring date 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
May 13, 2011#2209
Re: ISO8601 Std for Day in Year? 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
Aug 15, 2010#2208
Re: ISO8601 Std for Day in Year? 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
Aug 15, 2010#2207
Re: ISO8601 Std for Day in Year? 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
Jul 18, 2010#2206
Re: ISO8601 Std for Day in Year? 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
Jul 18, 2010#2205
Re: ISO8601 Std for Day in Year? 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
Jul 17, 2010#2204
ISO8601 Std for Day in Year? 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
Jul 17, 2010#2203
Re: How do I show in ISO 8601 the first quarter of every year [SEC=U ... 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;
Nov 6, 2009#2202
Re: How do I show in ISO 8601 the first quarter of every year [SEC=U 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
Nov 6, 2009#2201
How do I show in ISO 8601 the first quarter of every year [SEC=UNCLA 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
Nov 6, 2009#2200
How do I represent the first quarter of each year in ISO 8601 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
Nov 6, 2009#2199
Re: UTC didn't exist before 1961 ... 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
Jun 4, 2009#2198
Fetching Sponsored Content...
Re: UTC didn't exist before 1961 ... Personally, I think that would be fairly silly.
May 31, 2009#2197
Re: Ten Years On... 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
May 30, 2009#2196
Ten Years On... [2009-May-30] Ten years on, and some communities are still having healthy debate...
May 30, 2009#2195
Re: UTC didn't exist before 1961 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
May 29, 2009#2194
Re: UTC didn't exist before 1961 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
May 29, 2009#2193
Re: UTC didn't exist before 1961 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,
May 29, 2009#2192
Re: UTC didn't exist before 1961 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
May 29, 2009#2191
Re: UTC didn't exist before 1961 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
May 29, 2009#2190
Re: UTC didn't exist before 1961 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
May 29, 2009#2189
to bam 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
May 26, 2009#2188
Returned mail: User unknown The original message was received at 2009-05-26 23:15:29 -0400 from postoffice.local [10.0.0.1] ...
May 26, 2009#2183
Re: UTC didn't exist before 1961 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.
May 26, 2009#2182
Fetching Sponsored Content...
Re: UTC didn't exist before 1961 ... 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
May 26, 2009#2181
Re: UTC didn't exist before 1961 ... 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.
May 26, 2009#2180
Re: UTC didn't exist before 1961 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
May 25, 2009#2179
View First Topic Go to
Loading 1 - 30 of total 2,212 messages