How To Fix FDT_EXPRESSIONS017 - Invalid range parameters defined for 'Is ( Not ) Between' comparison

SAP Error Message - Details

• Message type: E = Error

• Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

• Message number: 017

• Message text: Invalid range parameters defined for 'Is ( Not ) Between' comparison

What causes this issue?

You have defined a comparison of type "is between" or "is not between"
where the incoming test parameter is compared against a range between a
low and a high value. However, the low value cannot be greater than or
equal to the high value. This is not allowed.

System Response

The expression containing the comparison cannot be activated.

How to fix this error?

Check the low and high value of the range serving as comparison
parameter and make sure that the high value is greater than the low
value.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FDT_EXPRESSIONS017 - Invalid range parameters defined for 'Is ( Not ) Between' comparison ?

  The SAP error message FDT_EXPRESSIONS017 indicates that there is an issue with the range parameters defined for a comparison operation using the "Is (Not) Between" condition in a formula or expression. This typically occurs in the context of SAP's Flexible Data Import (FDI) or similar data processing scenarios where expressions are evaluated.
  
  Cause:
  The error is caused by one or more of the following issues:
  
  Invalid Range Values: The lower and upper bounds of the range are not defined correctly. For example, the lower bound may be greater than the upper bound.
  Data Type Mismatch: The data types of the values being compared may not be compatible. For instance, comparing a string with a number.
  Null or Empty Values: One or both of the range parameters may be null or empty, which is not allowed for a "Between" comparison.
  Incorrect Syntax: There may be a syntax error in how the expression is written.
  
  
  Solution:
  To resolve the error,