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.