SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

days between function error in fast formula

User_R916CApr 29 2023

Hello,

There's a DAYS_BETWEEN function. I tried this in fast formula:

    Termination\_proration\_recovery\_days=DAYS\_BETWEEN((ADD\_MONTHS(XX\_FISCAL\_START\_DATE(sysdate),12)-1),EMP\_TERM\_DATE)

I get the following:

APP-FF-33006: The statement at line 71 has an invalid combination of data types

Cause: A statement contains an invalid combination of data types, for example an expression which contains sub-expressions of different data types.

Action: Ensure data types within expressions match.

Any idea what I'm doing wrong?

Added on Apr 29 2023

1 comment

747 views