How to find current week of the year

girish_firke · New User Joined: 29 Aug 2006 Posts: 3

hi,
actually I want to create a number 6 byte number out of which first 2 bytes will be week number and last 4 bytes will be year for the job run date.
ex. if my job runs on 27th sept. 2006 (week number :39) then I want to create a number which will have the value '392006'. (first 2 bytes week no: 39 and last 4 bytes 2006) ?
I have tried with julian dates. if I divide the days by 7 then quotient will be week of the year. but there is one problem suppose my 1 jan is on thursday and if my job runs on 5th (monday) so if I divide 5 by 7 it will give quotient as 0.
also I have to consider the leap year.

DavidatK · Posted: Thu Sep 28, 2006 1:58 am

Can you give us your definition of what a week is? Does the week start on a particular day, or does the week start on January 1st? As in your example, Jan 1 starts on thru. Is the first week Jan 1 - Jan 7 Thur - Wed?

Dave

girish_firke · New User Joined: 29 Aug 2006 Posts: 3

hi,
According international standards, Monday is first day of the week.
so I have to consider Monday to Sunday as a Week.
Generally If 1 Jan comes on Mon, tues, wed or Thursday then it will be consider as 1st week of the year. but if 1 jan comes on friday, saturday or sunday then it will be consider as last week of the previous year.
I want to calculate week for a date (any) on which my job will executes.

DavidatK · Posted: Thu Sep 28, 2006 11:00 pm

So, the first problem is to find out what day Jan 1 falls on. And if Jan 1 is in the last week of the previous year, or the first week of this year.

Search the forum, I think you will find a way of doing that.

Come back and we can work our way through the remainder of the problem.

Dave