Topic: Finding date difference excluding holidays. Posted: 11 Sep 2008 at 10:18pm
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged