Applying business hours, weekends and holidays

[ij76]

In CR V9.0

I have a report with a whack of variables all coming a datetime field. I need a formula for the datetime values which says if the hour is between 8:00pm and 7:59am change it to the following day (I guess it is 8:00 am the same day if the hour is from midnight to 7:59 am).

I then need to change the datetime to 8:00am the following Monday if it is between 8:00pm Friday to 7:59 am Monday.

Finally, I would need to apply holidays as well.

 

[synapsevampire]

The way that the big kids accomplish this in data warehousing is to add a table in to handle these sorts of details.

Check my FAQ:

faq767-4532

-k