Calculating no. of working days between tow dates

[Chinmay Ogale]

Can anybody help me in this issue?
If two dates are given then how can the no. of working days(excluding Sat. and Sun.) be calculated in Java. Anyn readymade methods available.

[Michael Dunn]

You want it served to you on a platter?

What have you tried since last asking this question?

http://forum.java.sun.com/thread.jsp?thread=555074&forum=31&message=2719384

[Chinmay Ogale]

Hi Michael,

I tried the code below-->public class WeekdayTest extends TestAbstract {

public static void main(String[] args) {
 
Date stdt = new Date();
String startdate = "15/09/2004";
String enddate = "18/09/2004";

SimpleDateFormat sdf = new SimpleDateFormat("dd/mm/yyyy");

try{
Date start = sdf.parse(startdate);
Date end = sdf.parse(enddate);
int workingDays = 0;
 
 
while(!start.after(end));
{
   int day = start.getDay();
   if ((day != Calendar.SATURDAY) || (day != Calendar.SUNDAY))
workingDays++;
System.out.println(workingDays);
   //start.add(Calendar.DATE, 1);
}

}catch(Exception e)
{
e.printStackTrace();
}
}
}
 

But in this case the while Loop goes into infinite loop. not getting exactly how to loop on 2 dates??

[ edited to preserve formatting using the [code] and [/code] UBB tags -ds ]
[ September 20, 2004: Message edited by: Dirk Schreckmann ]

[Paul Sturrock]

I'd take a look at the line:

while (!start.after(end));

Given how you've written this, how do you expect start or end to change?

I'd consider using Calendar objects instead of Date objects too. If you have a look at the methods avaliable to a Calendar object you'll see why.
[ September 20, 2004: Message edited by: Paul Sturrock ]

[Michael Dunn]

Hopefully the corrections are self-explanatory

import java.util.Calendar;
import java.text.SimpleDateFormat;
class WeekdayTest
{
  public static void main(String[] args)
  {
    //Date stdt = new Date();
    String startdate = "15/09/2004";
    String enddate = "18/09/2004";
    //SimpleDateFormat sdf = new SimpleDateFormat("dd/mm/yyyy"); mm = minute
    SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
    try
    {
      //Date start = sdf.parse(startdate);
      Calendar start = Calendar.getInstance();
      start.setTime(sdf.parse(startdate));
      //Date end = sdf.parse(enddate);
      Calendar end = Calendar.getInstance();
      end.setTime(sdf.parse(enddate));
      int workingDays = 0;
      while(!start.after(end))//removed ; (semi-colon)
      {
        //int day = start.getDay();
        int day = start.get(Calendar.DAY_OF_WEEK);
        //if ((day != Calendar.SATURDAY) || (day != Calendar.SUNDAY)) if it's sunday, != to Saturday is true
        if ((day != Calendar.SATURDAY) && (day != Calendar.SUNDAY))
        workingDays++;
        //System.out.println(workingDays);//moved
        start.add(Calendar.DATE, 1);//removed comment tags
      }
      System.out.println(workingDays);
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
}

[Chinmay Ogale]

Hi Michael,

Thanks for the solutions. It worked. I was not aware of calendar class. This relaly helped in learnign date related manipulations using java. Hope that u will help me in future also. Thanks once again.

Regards
Chinmay