francois.barrier Posted March 22, 2022 Share Posted March 22, 2022 Hello,I got an issue with an expression that we have written and with my colleague we don't issue where is the problem : Here the expression :($F{RECEIVEDDT}==null ? "N/A" :(LTRIM($F{SAMPLETYPEID}))=="Master Seed" ?(WORKDAY($F{RECEIVEDDT},2)) :(LTRIM($F{SAMPLETYPEID}))=="WS" ?(WORKDAY($F{RECEIVEDDT},4)) :"ERROR")The Goal is to calculate an expiry date, if Sample Type = MS, then Exp. Date = received date + 2 working daysIf Sample Type = WS, then Exp. Date = received date + 4 working days.In our case, the value for the test is Sample Type = WS, but the result of the expresion is always ERROR...Do you have any Idea ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now