Solved

I need a function that could return me the day worked.

Posted on 2008-06-11
2
155 Views
Last Modified: 2010-04-21
Hello guys

I need a function that could return me a quantity of days without weekend, since my first day of the month.

Thanks
0
Comment
Question by:hidrau
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
Russell Libby earned 500 total points
ID: 21763859
Give this a try, I believe it is pretty well tested. I wasn't sure if you were counting today in the result, or not (eg, if you consider today-yesterday = 2 days, or 1 day), so the function allows you to specify that.

As to the function, it determines how many weeks (full 7 days) have passed. That part is easy, because 7 days = 5. The remainer needs to be figured out based on day of the week that that the StartDate falls. (determine if the day count wraps into a weekend).

Regards,
Russell

----


function DaysWorkedSince(StartDate: TDateTime; IncludeToday: Boolean = False): Integer;
var  dwDay:         Integer;
     dwTotal:       Integer;
     dwWeeks:       Integer;
     dwDays:        Integer;
begin

  // Get the day of week for the starting day (0 = Sunday and 6 = Saturday)
  dwDay:=DateTimeToTimeStamp(StartDate).Date mod 7;

  // Subtract today and start date
  dwTotal:=Trunc(Now - StartDate);

  // Update by 1 if today should be included
  if IncludeToday then Inc(dwTotal);

  // Calculate the number of total weeks and remainder days
  dwWeeks:=dwTotal div 7;
  dwDays:=dwTotal mod 7;

  // Weeks = 5 working days
  result:=dwWeeks * 5;

  // Check remainder days
  if (dwDays > 0) then
  begin
     // Now figure in the days based on the starting date
     case dwDay of
        0  :  Dec(dwDays);
        1  :  if (dwDays > 5) then dwDays:=5;
        2  :  if (dwDays > 4) then dwDays:=4;
        3  :
        begin
           if (dwDays = 6) then
              dwDays:=4
           else if (dwDays > 3) then
              dwDays:=3;
        end;
        4  :
        begin
           if (dwDays > 3) then
              Dec(dwDays, 2)
           else if (dwDays = 3) then
              dwDays:=2;
        end;
        5  :
        begin
           if (dwDays > 2) then
              Dec(dwDays, 2)
           else if (dwDays = 2) then
              dwDays:=1;
        end;
        6  :
        begin
           if (dwDays > 2) then
              Dec(dwDays, 2)
           else
              dwDays:=0;
        end;
     end;
     // Update result
     Inc(result, dwDays);
  end;

end;

  ShowMessage(IntToStr(DaysWorkedSince(StrToDate('5/1/2008'), True)));
0
 
LVL 1

Author Closing Comment

by:hidrau
ID: 31466282
thanks

I tested and it is working.
If I have any problem I'll let you know
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 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