Jump to content
We've recently updated our Privacy Statement, available here ×

Issue with Text Field Expression


francois.barrier

Recommended Posts

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 days

If 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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...