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...
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...
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...
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...
All the parts of the standard that discuss Universal Time or time zones specify that everything is based on Coordinated Universal Time (UTC). But UTC didn't...
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...
Most people wouldn't believe that today different software gets different date/time results. Because: The industry does not have date/time standards for...
If you schedule a time to call someone, and you take your cell phone or appointment software to Europe, you will be reminded about a half dozen hours to ...
I got an email this morning, someone asking for some data from "03/09/07", I replied "We don't have data going back to 2003-09- 07". I then went about getting...
[2007-Jul-13] I see that the Wikipedia entry for ISO 8601 has been heavily edited, mostly by one person. Several sections of the article, things that have been...
In a message dated 7/1/2007 9:10:48 P.M. Central Daylight Time, PIEBALDconsult@... writes: Exactly. Plus, what if an "unknown future date" value finds its...
I had Not A Date:(NaD) 0000-00-00 unknown previous date 9999-990-99 unknown future date Duration and event must not be done on NAD Mine is simple. The...
It also works with ISO-8601 durations. PnYnMnDTnHnMnS Some samples, see attachment for more examples. Have not implemented calibrating a holiday on the Monday...
Therefore these are the same ph1m pt1m py1mh1m py1mT1m ph1my1m My rules are A "T'" or a "H" turn on time A "Y" turns off time Days and seconds are legal...
Read this attachment and be specific about the problems? did other not have the attachment? hjw ************************************** See what's free at...
In a message dated 6/21/2007 6:54:30 P.M. Central Daylight Time, PIEBALDconsult@... writes: Many of those characters didn't come across properly. But it...
Does ISO provide anything regarding representation of date and time in Luni Solar calendars where an intercalary month gets inserted in every three years or...
If you want to spread the ISO date format throughout the Internet Community, maybe you should consider all the available avenues and make use of them. You...
I have found Algorithms to convert Gregorian Year-Month-Day to ISO YearNumber-WeekNumber-Weekday and am looking for information to convert Gregorian...
“You wouldn’t believe how much time we wasted in the past doing things like reformatting dates for SQL statements, or converting COLeDateTimes (a cool ...
IBM C, Cobol, RPG had 31 decimal digit ability The US government demand 32 digit ability. The IBM best solution, give 63 digit ability. Non-techniques...
