NAME

Date::WeekOfYear - Simple routine to return the ISO 8601 week of the year (as well as the ISO week year)

SYNOPSIS

use Date::WeekOfYear;

# Get the week number (and year for the end/start of year transitions)
my ($wkNo, $year) = WeekOfYear();

# Get the week number for the time passed in time_stamp
my ($wkNo, $year) = WeekOfYear($time_stamp);

# Use the data for someThing ...
my $logFile = "/someDir/$year/someApp_$wkNo.log"

# Only want the week number, don't care which year in the week around
# the end/start of the year !
my $weekNo = WeekOfYear();

# Handle years outside of perls localtime functions - 04/01/2090
my ($wkNo, $year) = WeekOfYear({ year => 2090, month => 1, day => 4});

# or in ISO-8601 format YYYY-Wnn
my $iso_8601_wkno = WeekOfYear({ year => 2090, month => 1, day => 4}, WOY_ISO_MODE);

# Week number as per pre V1.5
my ($wkNo, $year) = WeekOfYear($time_stamp, WOY_OLD_MODE);

DESCRIPTION

Date::WeekOfYear is small and efficient. The only purpose is to return the week of the year. This can be called in either a scalar or list context.

In a scalar context, just the week number is returned (the year starts at week 1).

In a list context, both the week number and the year (YYYY) are returned. This ensures that you know which year the week number relates too. This is only an issue in the week where the year changes (ie depending on the day you can be in either week 52, week 53 or week 1.

NOTE The year returned is not always the same as the Gregorian year for that day for further details see ISO 8601.

To obtain the old functionality, a mode is also passed, WOY_OLD_MODE. Note you need to use the ':mode' or ':all' tags to use to gain access to WOY_OLD_MODE.

If mode WOY_ISO_MODE is used the output will be in the ISO 8601 format YYYY-Wxx where YYYY is the year and xx is the two digit week number and 'W' denotes week.

MODES

If a second argument, the mode, is provided then either the pre version 1.5 mode is activated or the output is format as per ISO 8601 as YYYY-Wxx

The modes are WOY_OLD_MODE and WOY_ISO_MODE

WOY_OLD_MODE

Used to select the old mode, eg

($wkNo, $year) = WeekOfYear($time_stamp, WOY_OLD_MODE);

WOY_ISO_MODE

Use to select the output formatted as YYYY-Wxx, eg

$iso_8601_wkno = WeekOfYear({ year => 2090, month => 1, day => 4}, WOY_ISO_MODE);

DEFAULT EXPORT

WeekOfYear

The function, see SYNOPSIS above

OTHER FUNCTIONS

These other functions are available if the use tag ':all' is used, eg:

use Date::WeekOfYear ':all';

day_of_year

Returns the day of the year, 1 being the first day. The last day is either 365 or 366, the latter if the year is a leap year. Expected arguments are the year, month and day as numeric values. The year is expected as yyyy, the month as 1 to 12 for Jan to Dec and the day of the month.

is_leap_year

Returns true (1) if the year is a leap year, otherwise false (0). The expected argument is the year as a numeric value of format yyyy, eg 2014.

In general terms the algorithm for calculating a leap year is as follows...

A year will be a leap year if it is divisible by 4 but not by 100. If a year is divisible by 4 and by 100, it is not a leap year unless it is also divisible by 400. Thus years such as 1996, 1992, 1988 and so on are leap years because they are divisible by 4 but not by 100. For century years, the 400 rule is important. Thus, century years 1900, 1800 and 1700 while all still divisible by 4 are also exactly divisible by 100. As they are not further divisible by 400, they are not leap years.

jan1week_day

Returns the week_day of the 1st of January for the year in question. The week_day is a numeric value indicating the day and differs from that returned by the core function localtime() in that Sunday is 7 rather than 0.

The returned values are:

1=Mon, 2=Tue, 3=Wed, 4=Thu, 5=Fri, 6=Sat and 7=Sun

The expected argument is the year in yyyy format, eg 2014.

week_day

week_day takes the year (yyyy eg 2014), month (1 to 12) and month_day as arguments and returns the week day.

The week day returned is an integer representing the day of the week where:

1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday.

Note this is similar to that returned by localtime except that Sunday is 7 rather than 0

week_number

week_number takes the year (yyyy eg 2014), month (1 to 12) and month_day as arguments and returns the week number as defined by ISO-8061. That is week 1 starts on a Monday and contains the first Thursday in the year. As a result week 1 can start in the previous year and a year can have either 52 or 53 weeks.

CHANGES

As of version 1.5 the ISO 8601 week number is calculated. For backwards compatibility a flag can be passed after the time to give the previous functionality.

For example:

my $weekNo = WeekOfYear(undef, 1);  # Week number now in pre ISO 8601 mode
or
my $weekNo = WeekOfYear($the_time, 1);  # Week number for $the_time in pre ISO 8601 mode

ISO 8601

Weeks in a Gregorian calendar year can be numbered for each year. This style of numbering is commonly used (for example, by schools and businesses) in some European and Asian countries, but rare elsewhere.

ISO 8601 includes the ISO week date system, a numbering system for weeks - each week begins on a Monday and is associated with the year that contains that week's Thursday (so that if a year starts in a long weekend Friday-Sunday, week number one of the year will start after that). For example, week 1 of 2004 (2004W01) ran from Monday 29 December 2003 to Sunday, 4 January 2004, because its Thursday was 1 January 2004, whereas week 1 of 2005 (2005W01) ran from Monday 3 January 2005 to Sunday 9 January 2005, because its Thursday was 6 January 2005 and so the first Thursday of 2005. The highest week number in a year is either 52 or 53 (it was 53 in the year 2004).

An ISO week-numbering year (also called ISO year informally) has 52 or 53 full weeks. That is 364 or 371 days instead of the usual 365 or 366 days. The extra week is referred to here as a leap week, although ISO 8601 does not use this term. Weeks start with Monday. The first week of a year is the week that contains the first Thursday (and, hence, 4 January) of the year. ISO week year numbering therefore slightly deviates from the Gregorian for some days close to 1 January.

Calculations

Ordinal Day

If the ordinal date is not known, it can be computed by any of several methods. perhaps the most direct is a table such as the following:

To the day of:  Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Add:            0   31  59  90  120 151 181 212 243 273 304 334
For leap years: 0   31  60  91  121 152 182 213 244 274 305 335

Week Number

Calculating the week number of a given date

The week number of any date can be calculated, given its ordinal date (i.e. position within the year) and its day of the week.

Method: Using ISO weekday numbers (running from 1 for Monday to 7 for Sunday), subtract the weekday from the ordinal date, then add 10. Divide the result by 7. Ignore the remainder; the quotient equals the week number. If the week number thus obtained equals 0, it means that the given date belongs to the preceding (week-based) year. If a week number of 53 is obtained, one must check that the date is not actually in week 1 of the following year.

week(date) = int((ordinal(date) - weekday(date) + 10)/7)

Example: Friday 26 September 2008

Ordinal day: 244 + 26 = 270
Weekday: Friday = 5
270 - 5 + 10 = 275
275 / 7 = 39.28
Result: Week 39

53 Week Years

The long years, with 53 weeks in them, can be described by any of the following equivalent definitions:

- any year starting on Thursday and any leap year starting on Wednesday
- any year ending on Thursday and any leap year ending on Friday
- years in which 1 January and 31 December (in common years) or either (in leap years) are Thursdays

Day of Week

The tabular forerunner to Tondering's algorithm is embodied in the following ANSI C function. With minor changes, it is adaptable to other high level programming languages such as APL2. (A 6502 assembly language version exists as well.) Devised by Tomohiko Sakamoto in 1993, it is accurate for any Gregorian date:

int dow(int y, int m, int d)
{
    static int t[] = {0, 3, 2, 5, 0, 3, 5, 1, 4, 6, 2, 4};
    y -= m < 3;
    return (y + y/4 - y/100 + y/400 + t[m-1] + d) % 7;
}

The function returns 0 = Sunday, 1 = Monday, etc.

KNOWN ISSUES

Versions prior to 1.5 did not follow ISO 8601.

None, however please contact the author at gng@cpan.org should you find any problems and I will endevour to resolve then as soon as possible.

AUTHOR

Greg George, IT Technology Solutions P/L, Australia
Mobile: +61-404-892-159, Email: gng@cpan.org

SEE ALSO

Date::Parse or check CPAN http://search.cpan.org/search?query=Date&mode=all

ACKNOWLEDGEMENTS

Thanks to Alexandr Ciornii for the V1.3 updates Thanks to Niel Bowers for [rt.cpan.org #93599] Not clear what type of week number is returned

Log

Revision 1.7 2020/01/04 Greg - Resolved issue with tests failing. Now pass the full 4 digit year to timelocal() to avoid ambigous date values. - No changes to the actual code

Revision 1.6 2014/04/09 Greg - Allow extended date coverage - past dates handled by localtime - using hash ref argument year, month, day - Added mode for ISO 8601 output YYYY-Wxx

Revision 1.5 2014/03/16 Greg - Updated to conform to ISO 8601 - Added compatability flag to allow backwards usage

Revision 1.4 2009/06/21 07:29:05 Greg - Added ACKNOWLEDGEMENTS

Revision 1.3 2009/06/20 09:31:39 Greg - Real tests with Test::More - Tests moved to t/ - Better Makefile.PL - Now WeekOfYear can take an argument (unixtime)

Revision 1.2 2006/06/11 02:28:55 Greg - Correction to name of function

Revision 1.1.1.1 2004/08/09 11:07:15 Greg - Initial release to CPAN

CVS ID

$Id: WeekOfYear.pm,v 1.4 2009/06/21 07:29:05 Greg Exp $