Calculating end date while skipping holidays + Joda time

views:

180

answers:

Calculating end date while skipping holidays + Joda time

I would like to calculate end date (and time) of an event. I know starting date and duration (in minutes). But:

I have to skip holidays - non-recurrent situation
I have to skip weekends - recurrent situation
I have to not count working time (e.g: from 8:00am till 5:00pm) - recurrent situation, but with finer granularity

Is there a simple way to achieve these cases using Joda time library?

+1 A:

First you have to define "holidays". Not every locale has the same ones, so this has to be made generic and pluggable.

I don't think it's "simple".

duffymo 2010-05-01 19:49:05

In my case holidays are stored in a database. But I wanted to point out that I cannot use: if(dayofweek() == 7) { skip(); }

picca 2010-05-02 07:35:48

+1 A:

Have you looked into Holiday calculation project? it is featured in the Related projects from jodatime and could be useful

raticulin 2010-05-01 19:50:28

Looks really good. But I still don't know how to handle working hours. I basically need to fast-forward given date by N-minutes. Skipping working hours, holidays, etc...

picca 2010-05-02 08:37:56

+1 A:

Jodatime will help you -a lot I'd say-, but you'll need to write the logic yourself, a loop skipping some entire days and some times of the day. Not very simple, neither very complex, it seems to me.

leonbloy 2010-05-03 13:48:23

Marking as accepted answer, because it's true. According to my researches, there is no simple solution. And Jodatime is definetly helpful.

picca 2010-05-04 18:15:38

ansaurus

tags:

views:

answers:

Calculating end date while skipping holidays + Joda time

related questions