This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calculate Business Days between two dates using java

 
pallavi chaudhari
Ranch Hand
Posts: 54
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi experts,

I want to find the business days between two dates. I found following solution on google.


Is it good way to calculate business days?

Suggest a solution

Thanks
 
Paul Clapham
Sheriff
Pie
Posts: 20196
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it works for your test cases, then yes, it's a good way. But if it doesn't, then no, it isn't a good way.

What I'm saying: Set up some test cases and run the code to see if it produces the answer you want.
 
Rob Spoor
Sheriff
Pie
Posts: 20393
46
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't like the loop's guard. It's too precise. What if you want to calculate the difference in days between 2011-08-08 09:00 and 2011-08-08 18:00? Your code would result in one day, whereas it should be 0 days.

The following should be a better guard:
 
fred rosenberger
lowercase baba
Bartender
Pie
Posts: 12022
25
Chrome Java Linux
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is impossible to say if this is good or bad until you define what is a business day and what isn't. I work in healthcare, so EVERY day is a business day. Do you need to account for national holidays?

 
Rob Spoor
Sheriff
Pie
Posts: 20393
46
Chrome Eclipse IDE Java Windows
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wrote an entire library at work (which means I can't share the code...) that can calculate the difference in both days and minutes between any two timestamps, including opening and closing times and holidays - all configurable of course. It wasn't easy though.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic