topic Re: [resolved] Difference between two dates excluding weekends in Talend Studio

[resolved] Difference between two dates excluding weekends

Anonymous — Wed, 21 Oct 2015 11:11:34 GMT

Hi,
I have a scenario where I have two dates in two columns(Create date and As of date) which comes in a file.
I have to find the number of working days in between these two dates where the count excludes the weekends(Saturday and Sunday).
Appreciate if I get the code to be written in Talend open Studio.
Thanks
Pradhab

Re: [resolved] Difference between two dates excluding weekends

Anonymous — Wed, 21 Oct 2015 14:23:11 GMT

Hello,
Maybe you can create a routine and implement a method in this routine doing what you want.
An example of method could be :

public class NumberOfDays {
    static int day_of_week;
    public static Integer getNumberOfDaysWorked(java.util.Date beginDate,java.util.Date endDate){
	   Integer val = 0;
	   while (beginDate.before(endDate)){
		   day_of_week=TalendDate.getPartOfDate("DAY_OF_WEEK", beginDate);
		   if(day_of_week != 1 && day_of_week != 7){// 1 is for Sunday and 7 is for Saturday
			   val = val+1;
		   }
		   beginDate = TalendDate.addDate(beginDate, 1, "dd");
	   }
	   return val;
   }
}

After that you call this method in a Tmap.
I hope it can help you.

Re: [resolved] Difference between two dates excluding weekends

Anonymous — Fri, 30 Oct 2015 10:07:20 GMT

Thanks you so much for the code. I created a routine and implemented the method in it and called the method in the tmap in Talend. It worked as expected.
Thanks
Pradhab

Re: [resolved] Difference between two dates excluding weekends

Anonymous — Fri, 30 Oct 2015 10:29:20 GMT

You are welcome.
I think you can mark this post as 'resolved'.