Post Author: dkotenoglou
CA Forum: Formula
Thanks to the people here I was able to get a nice formula to help me calculate the amount of business days between two days.//Crystal syntax
Local DateTimeVar d1 := ;
Local DateTimeVar d2 := ;
DateDiff ("d", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday) This works great. I wanted to add the ability to omit US Holidays. Now this is a straight Crystal Reports install without an SQL backend so I cannot use any formulas there.Is there a parameter? I can use to manually create a table of dates to omit? The only reason I ask is that our company was closed during the holidays so my day reports are really high. I do not mind typing a long list of days manually (12/24/2007, 12/25/2007, etc) but I need to know how to best integrate that list into the formula.