calcuate the week number of a given date Post: 83039

Sponsored Content

Top Forums Shell Programming and Scripting calcuate the week number of a given date Post 83039 by Perderabo on Friday 9th of September 2005 01:15:14 PM

09-09-2005

Administrator Emeritus

Thanks for posting your final solution. I don't recall ever hearing of ISO week numbers before. So I will add this thread to our date arithmetic FAQ article. I found this page which has an on-line calculator for ISO week numbers.

For the record, here is a datecalc based solution. It emulates the behavior of the on-line calculator in that it outputs a year, a week number, and a day of week number...

Code:

#! /usr/bin/ksh
month=$1
day=$2
year=$3
typeset -Z2 fwk

function calcisoweek
{
        integer year month day dow1y mjd1y mjd isoweek
        year=$1
        month=$2
        day=$3
        dow1y=$(datecalc -d $year 1 1)
        ((dow1y=(dow1y+6)%7))
        mjd1y=$(datecalc -j $year 1 1)
        mjd=$(datecalc -j $year $month $day)
        ((isoweek=(mjd - mjd1y - dow1y + 7 + 3 )/7))
        echo $isoweek
        return 0
}

dow=$(datecalc -d $year $month $day)
((!dow)) && dow=7
fwk=$(calcisoweek $year $month $day)
if ((!fwk)) ; then
        ((year=year-1))
        fwk=$(calcisoweek $year 12 31)
fi
echo ${year}-W${fwk}-${dow}
exit 0

Perderabo

View Public Profile for Perderabo

Find all posts by Perderabo

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to obtain date and day of the week from `date` command

Hi, does anybody know how to format `date` command correctly to return the day of the week? Thanks -A I work in ksh....

2. Shell Programming and Scripting

Date One Week Ago From Given Date, Not From Current Date

Hi all, I've used various scripts in the past to work out the date last week from the current date, however I now have a need to work out the date 1 week from a given date. So for example, if I have a date of the 23rd July 2010, I would like a script that can work out that one week back was...

3. Shell Programming and Scripting

Know the number of the week for a date

Hi, I tried to find the solution on the forum without success. datecalc from Perderabo doesn't solve my problem. I would like to know how to do the same thing that date +%U but for a specific date. For example: 2011 08 27 => 39 Thinks a lot

4. Shell Programming and Scripting

Extract week start,end date from given date in PERL

Hi All, what i want to do in perl is i should give the date at run time .Suppose date given is 23/12/2011(mm/dd/yyyy) the perl script shold find week start date, week end date, previous week start date,end date,next week start date, end date. In this case week start date will be-:12/19/2011...

5. Shell Programming and Scripting

Week number from a date.

Hi, How can we get the week number from any paricular date. lets say date is 20120404 (YYYYMMDD) then how to get the week number? date +%W --- Thic command gives the week number for current date only. Thanks.

6. AIX

How to calcuate total number of weeks?

Hi anyone can help? How to calculate total number of weeks from a specify date, for example, 01 Jan 2012. Thx! https://www.unix.com/images/misc/progress.gif

7. Shell Programming and Scripting

Find week of the year for given date using date command inside awk

Hi all, Need an urgent help on the below scenario. script: awk -F"," 'BEGIN { #some variable assignment} { #some calculation and put values in array} END { year=#getting it from array and assume this will be 2014 month=#getting it from array and this will be 05 date=#...

LEARN ABOUT SUSE

cal

CAL(1)							    BSD General Commands Manual 						    CAL(1)

NAME

     cal -- displays a calendar

SYNOPSIS

     cal [-smjy13] [[[day] month] year]

DESCRIPTION

     Cal displays a simple calendar.  If arguments are not specified, the current month is displayed.  The options are as follows:

     -1      Display single month output.  (This is the default.)

     -3      Display prev/current/next month output.

     -s      Display Sunday as the first day of the week.

     -m      Display Monday as the first day of the week.

     -j      Display Julian dates (days one-based, numbered from January 1).

     -y      Display a calendar for the current year.

     -V      Display version information and exit.

     A single parameter specifies the year (1 - 9999) to be displayed; note the year must be fully specified: ``cal 89'' will not display a calen-
     dar for 1989.  Two parameters denote the month (1 - 12) and year.	Three parameters denote the day (1-31), month and year, and the day will
     be highlighted if the calendar is displayed on a terminal.  If no parameters are specified, the current month's calendar is displayed.

     A year starts on Jan 1. The first day of the week is determined by the locale.

     The Gregorian Reformation is assumed to have occurred in 1752 on the 3rd of September.  By this time, most countries had recognized the ref-
     ormation (although a few did not recognize it until the early 1900's.)  Ten days following that date were eliminated by the reformation, so
     the calendar for that month is a bit unusual.

HISTORY

     A cal command appeared in Version 6 AT&T UNIX.

OTHER VERSIONS

     Several much more elaborate versions of this program exist, with support for colors, holidays, birthdays, reminders and appointments, etc.
     For example, try the cal from http://home.sprynet.com/~cbagwell/projects.html or GNU gcal.

AVAILABILITY

     The cal command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/.

BSD
								   June 6, 1993 							       BSD

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to obtain date and day of the week from `date` command

Discussion started by: aoussenko

2. Shell Programming and Scripting

Date One Week Ago From Given Date, Not From Current Date

Discussion started by: Donkey25

3. Shell Programming and Scripting

Know the number of the week for a date

Discussion started by: Castelior

4. Shell Programming and Scripting

Extract week start,end date from given date in PERL

Discussion started by: parthmittal2007