Solved

Calculating Work Week Ranges

Posted on 2006-07-12
6
942 Views
Last Modified: 2008-02-01
I have two things I wish to accomplish:

1)  Based on the current date determine the StartDate of the current Work Week  and the End Date of the current Work Week.  

2)  Based on the current date generate a list of  the prior 10 work week ranges and the upcoming 10 work week ranges.  

 I would like to implement both of these as public methods within a class.  My language of choice is C#

Thanks In Advance
0
Comment
Question by:DylanJones1
6 Comments
 
LVL 35

Expert Comment

by:mrichmon
ID: 17092335
It is simply math.

Assume that a week starts on Sunday and ends on SAtruday.  Then the formula is:

DateTime today = DateTime.Now.Date;
DateTime weekStart;
DateTime weekEnd;

// Calculate the start date
weekStart = today.AddDays(-((int)today.DayOfWeek));

// End date can be calculated based on adding 6 days to weekStart or manually as:
weekEnd = today.AddDays(6-((int)today.DayOfWeek));

As for the 10 work ranges, just do a loop subtracting 7 days from teh start date for each week range you want.
0
 
LVL 1

Expert Comment

by:flashaoy
ID: 17092336
There is one big problem with work week calculations. Observered holidays, see :http://www.codeproject.com/dotnet/HolidayCalculator.asp for that. After that work week is trivial.

0
 
LVL 7

Expert Comment

by:whatsit2002
ID: 17092534
mrichmon seems to have the correct solution so please do not award any points to this comment. I just wanted to chime in and and say, this is how you do it in SQL just in case someone stumbles across this and wonders:

DECLARE @Today AS DATETIME
SET @Today = GETDATE()

SELECT DATEADD(wk, DATEDIFF(wk, 0, @Today), 0) AS Monday, DATEADD(wk, DATEDIFF(wk, 4, @Today), 4) AS Friday


Jason
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:DylanJones1
ID: 17092659
Want to thank you all for you quick input.  I guess the wrinkle I failed to communicate is that I need to determine the current range on any given day.


Given today  07/12/2006 the current date range is

Work week start date 07/10/2006   work week end date  07/15/2006 - we work saturdays :-(

So basically given the current date I need to determine the date of the prior monday and the date of the upcoming saturday.

0
 
LVL 35

Expert Comment

by:mrichmon
ID: 17092662
flashaoy,

It actually depends.  At least in all of the applications I have written or worked on a work week is a work week, regardless of holidays.  Now business days are a different matter.  A work week may or may not consist of 5 business days depending on holidays.

So my above is for a work week - not business days.
0
 
LVL 35

Accepted Solution

by:
mrichmon earned 500 total points
ID: 17092676
Very easy.  My solution is for Suday to Satruday.

If you want Monday to Satureday then simply do:

weekStart = today.AddDays(-((int)today.DayOfWeek)).AddDays(1);
weekEnd = today.AddDays(6-((int)today.DayOfWeek));
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Bit flags and bit flag manipulation is perhaps one of the most underrated strategies in programming, likely because most programmers developing in high-level languages rely too much on the high-level features, and forget about the low-level ones. Th…
This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now