Determine specific date within a date range 1

[ETCS]

Hey all,

I have a report used for determining whether or not a task was completed within service level agreements. Basically I am calculating the date diff to make this determination. However, holidays are giving me some heartburn. I need a way to determine whether or not a holiday fell between the start and end dates so I can adjust the date diff calculation in a way that the holiday doesn't count against the time to completion. I have a formula that contains all of the holidays taken by the company but I can't figure out how to determine if one of those holiday dates falls in the range of the start date to finish date.

Any help would be greatly appreciated. I am using Crystal 11 with a SQL database back end.

Thanks!

 

[lbass]

Please see:

http://www.kenhamady.com/form01.shtml.

-LB

 

[ETCS]

Thanks LB! This worked perfectly.