I am using IFS 8 and no matter what I have put in as an Expression, I get the error that the expression must return a date. I tried the solutions in other Topics, but none work for me.
I even tried something really simple: SYSDATE + 1/3600; which comes directly from IFS Online Documentation and get the same error.
Is there something weird about IFS 8?
Any help is appreciated.
I discovered that the problem is with the “Check” button. Everything fails validation.
However, if the expression works in SQLPLUS, then it works in IFS. I just put the Expression in and Saved. If it saves, then it is OK.
I recall there being a bug problem with the expression field in IFS V8. It was corrected in IFS V9. I’ve looked through my email, but can’t recall when we ran across that problem or what the nature of the bug was, just sounds familiar.
Try: to_date(field, ‘DD/MM/YYYY’)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.