Re: Get Start Date of a Week Number

On Mon, Dec 1, 2014 at 2:32 PM, <rob@xxxxxxxxx> wrote:

I wonder if there should be a YEAR_ISO function.

I think there should be. In Python, date and datetime objects have a
method called isocalendar() which returns a tuple consisting of the
ISO year, ISO week number, and ISO weekday.

It's necessary to provide all three numbers to uniquely identify a
date, just as it's necessary to provide the year, month, and day when
specifying a Gregorian calendar date.

I was thinking of grouping over more than one year.
... where WEEK_ISO=x and YEAR_ISO=y...
kind of thing.

Right. How can you compare year-over-year (to take just one example)
if you can't tell what year your data is in? I guess maybe using ISO
weeks for such things Just Isn't Done? (I wouldn't know; we don't use
ISO weeks at all where I work. Actually, I don't know if anyone else
in the company has even heard of ISO week numbers.)

John Y.