When using the ‘not between’ function in a Fast Formula, I encounter an error related to the condition ‘(ACP_HIRE_DATE < HWM_PPM_TM_START_TIME or ACP_HIRE_DATE > HWM_PPM_TM_STOP_TIME)’. Does anyone know what could be causing this issue with the function or if this error is originating from the DBI?

The expected result is to understand the root cause of the error encountered when using the ‘not between’ function in a Fast Formula with the condition (ACP_HIRE_DATE < HWM_PPM_TM_START_TIME or ACP_HIRE_DATE > HWM_PPM_TM_STOP_TIME). By seeking clarification or insights from others, the aim is to identify whether the issue lies within the function itself or if it’s originating from the Database Item (DBI).