Loading ...
Sorry, an error occurred while loading the content.

Messages List

2212

Re: Recurring date

... ISO 8601 requires two digits for the day of the month: R/0000-07-01/P1Y Michael Deckers.
Michael Deckers
May 15, 2011
#2212
 
2211

Re: Recurring date

A recurring time interval that starts on 0000-07-1 with duration of one year: R/0000-07-1/P1Y
piebaldconsult
May 14, 2011
#2211
 
2210

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
 
2209

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
marcus.aurelia
May 13, 2011
#2209
 
2208

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
Paul Myers
Aug 15, 2010
#2208
This message has attachments
  • TXT
    5 KB
    frmFormatCell.frm
2207

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
Will Scott
Aug 15, 2010
#2207
 
2206

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
Tex Texin
Jul 18, 2010
#2206
 
2205

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
John Bogie
Jul 18, 2010
#2205
 
2204

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
Tex Texin
Jul 17, 2010
#2204
 
2203

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
prmyers1
Jul 17, 2010
#2203
 
2202

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;
piebaldconsult
Nov 6, 2009
#2202
 
2201

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
johnmsteele
Nov 6, 2009
#2201
 
2200

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
john.hockaday@...
Nov 6, 2009
#2200
 
2199

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
jhock96
Nov 6, 2009
#2199
 
2198

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
Deckers, Michael
Jun 4, 2009
#2198
 
View First Topic Go to View Last Topic
Loading 1 - 15 of total 2,212 messages