Date formula assistance

[Gramm]

Greetings...
I need to locate a method to detect holidays in order to exclude them in the reports. Using XI.
Thank you

 

[CoSpringsGuy]

If you are able, you could create a table in your database to hold the holiday info.

If you dont have that ability (I dont because our DB is proprietary and I cant get into it) maybe you could create a holiday table in another DB and link it to your report.

The only other way that I am aware of is to hard code those dates in the report itself. Several different ways to do that but the drawback is that if holidays change, the code has to change.

Im sure someone else out there has some better approaches....



_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[dgillz]

Checkout Ken Hamady's website, click on the formulas link, and he has a way to do this.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[AndyMc]

Gramm,

Here is the site dgillz mentioned. Note formulas 1, 13, 17, 25,& 26.

http://kenhamady.com/formula.html

Andy

 

[Gramm]

Got it...thanks