AnsweredAssumed Answered

Status

Question asked by thong127 on Nov 6, 2009
Latest reply on Nov 6, 2009 by DLW-BPEX

Title

Status

Post

Hi to Everybody,

 

Just want to ask your help.

 

I have a 3 fields Expiry Date & Retest Date & Status.

 

In my status field I want to show that a certain product is "Active" or "Expired" based from Expiry Date or Retest Date. my calculation is

 

Case ( Get ( CurrentDate )  > Expiry Date & Retest Date; "Expired";
       Get ( CurrentDate ) + 3650> Expiry Date; "Active"
)

 

 

but it doesnt give me my desired result. Kindly help me improve my calculation in the Status.

 

Thank you very much.

 

Best regards,

 

 

thong

 

 

 

Outcomes