Simple...If both are already DATE type, command should be:
MONTHS_BETWEEN(SYSDATE,DUE_DATE)
If due date is in the past, result will be a positive number.
If due date is in the future, result will be a negative number.
|
Results 1 to 4 of 4
Thread: Months betweenThreaded View
|
Click Here to Expand Forum to Full Width |