Hi,

I am facing a problem in finding difference between 2 given dates in datetime format in Crystal Reports 2008. There is 'DateDiff()' function available, but it gives the mathematical difference between 2 dates. I want to exclude the holidays from this difference.
The data for the holidays is stored in a database table 'Holidays' having 2 columns as 'Year' & 'Day' (both columns' datatype in the table is integer). the 'Day' column stores the day of the year in the range 1 to 366 and 'Year' column stores the year in 4-digit format.

Please help me.

Regards,
Nicks.


Edited by nicks - 11 Sep 2008 at 11:19pm