Help with calc using if or case

[Davos]

I have a evidence database that I need to invoice. If the field PAID THRU is greater than the current date and the fields DATE DESTROYED and DATE TRANSFERRED are empty I need it to return a “Yes” in order to invoice the evidence. I can’t figure out why the following calculation for the field “TIME TO INVOICE EVIDENCE” will not work. It also needs to return a “Yes” if the field paid thru is empty and there is no data in the fields DATE DESTROYED and DATE TRANSFERRED. Please help.

If ( Cases Evidence CASENO::Paid Thru < Get ( CurrentDate ) ; "Yes" ; If (not IsEmpty(Cases Evidence CASENO::Date Destroyed) and not IsEmpty(Cases Evidence CASENO::Date Destroyed) ; "NO" ; "Can’t Figure This Out !"))

[Raybaudi]

Case(

IsEmpty ( Date Destroyed ) and IsEmpty ( Date Transferred ) ;

Case(

Paid Thru > Get ( CurrentDate ) or IsEmpty ( Paid Thru ) ; "Yes" ;

"No"

) ;

"No"

)

[Davos]

I truly appreciate your response, but that didnt work either.

[Genx]

Case(

(PAID THRU > Get(CurrentDate) or IsEmpty(PAID THRU)) and IsEmpty(Date Destroyed) and IsEmpty(Date Transferred) ; "Yes" ; "No" )

Also make sure the box "do not evaluate if all referenced fields are empty" is unchecked.

[Davos]

That worked, thanks soooo much, I'm sorry forthe delayed response, I have been on vacation.