Suppress formula for report footer

[tib97]

I will try to make this as easy to understand as possible....
I work in a shelter and we are required to hold stray animals for specific lengths of time determined by the town they were found in. However, we do NOT count holidays within that hold time since we are closed and the public cannot come personally to look. We are open 7 days a week.

I am trying to figure out how to make the report footer of our kennel card suppress when someone enters the due out date incorrectly when there is a holiday involved, no matter what day of the week the holiday falls on.

I have used KenHamady.com for the holiday/day of week formulas and think I have it tweaked to cover all days of the week. I just need to know how to tell the suppress function to suppress the footer if the due out date is incorrect. Here is the formula I have been working with, but it does not recogzine the holiday function and I can't figure out how to do it. Do I need to add something in my @DateDiff formula (included below)?

if {KENNEL.intake_type} = 'STRAY' AND {KENNEL.jurisdiction} in ['a', 'b','c'] AND {@DateDiff} < 4 then "INCORRECT DUE OUT DATE! PLEASE CORRECT AND REPRINT!" ELSE
IF {KENNEL.intake_type} = 'STRAY' AND {kennel.jurisdiction} in ["d", "e", "f", "g", "h", "i", "j", "k", "l"] AND {@DateDiff} <6 then "INCORRECT DUE OUT DATE! PLEASE CORRECT AND REPRINT!"

DateDiff ("d",{KENNEL.intake_date},{KENNEL.due_out})

Thanks everyone!!!!

 

[NickieP]

In Section Expert, the suppress footer(X2) formula field it should say:

{@DateDiff}like "INCORRECT DUE OUT DATE! PLEASE CORRECT AND REPRINT!"

after saving , the X2 box now turns red but the suppress footer box is unchecked
(meaning there is a supression rule but it is conditional)

That will only work if the footer belongs to one record.Otherwise, you would need a summarised field to decide when to suppress